Web Method Attibutes

"Retrives collection of StatusCode details for the project", EnableSession = false)]public StatuscodeInfo[] GetStatusCodes(string key)null;try{
DbConnect db =
DataSet odtset = db.GetValuesFromDb(key);

{

{
StatusInfo =

{
StatusInfo[ILM0] =
StatusInfo[ILM0].statuscodeid =
StatusInfo[ILM0].statusname = odtset.Tables[0].Rows[ILM0][
}
}
}
new DbConnect();if (odtset != null)if (odtset.Tables.Count > 0)new StatuscodeInfo[odtset.Tables[0].Rows.Count];for (Int16 ILM0 = 0; ILM0 < odtset.Tables[0].Rows.Count; ILM0++)new StatuscodeInfo();Convert.ToInt32(odtset.Tables[0].Rows[ILM0]["statuscodeid"]);"statuscodeshortname"].ToString();else{

}
}

{

}

}



////////////////////////////////////////
////////////class

using System;///
/// <summary> Summary description for FieldInfo/// </summary>public class FieldInfo{


}public Int32 Fieldid;public string Fieldname;

// Read Config By Key Value

using System;///
/// <summary> Summary description for Readconfig/// </summary>public class Readconfig{

{
}

{

public Readconfig()public static String ReadSetting(String key)String defaultValue = "";try{



setting =

defaultValue = (
}

{
defaultValue =
}

}

}


// Db Connection

using System;using System.Data;using System.Data.SqlClient;///
/// <summary> Summary description for DbConnect/// </summary>public class DbConnect{

{
public DbConnect()//// TODO: Add constructor logic here//}



public SqlConnection oCon;/// <summary>/// Config key Validations/// </summary>/// <param name="key">key</param>/// <returns>Project name or Project Id </returns>
{
public string ReadConnString(string key)try{



oCon = GetConnection(ConnectionString);

}

{

}
}

String ConnectionString = Readconfig.ReadSetting(key);if (ConnectionString == "" || ConnectionString == null)throw new Exception("The parameter ConnString should not be empty");return ConnectionString;catch (Exception e)throw new Exception(e.Message);/// <summary>/// Connection String Validations/// </summary>/// <param name="ConnectionString"></param>/// <returns></returns>
{
public SqlConnection GetConnection(String ConnectionString)try{


oCon =
}

{

if (String.IsNullOrEmpty(ConnectionString))throw new Exception("Invalid Connection String.Connection String Should Not Be Empty or Null");new SqlConnection(ConnectionString);catch (Exception e)throw new Exception(e.Message);//Console.WriteLine("Exception: {0}", e.ToString());}

}
return oCon;/// <summary>/// To Return the dataset /// </summary>/// <param name="ConnectionString"></param>/// <returns></returns>

{

public DataSet GetValuesFromDb(string key)string connection = ReadConnString(key);try{
DataSet oDtset =
SqlDataAdapter oDAdap =
SqlCommand ocmd =
oCon = GetConnection(connection);

oCon.Open();
ocmd.Connection = oCon;
ocmd.CommandText =
ocmd.CommandType = CommandType.StoredProcedure;
oDAdap.SelectCommand = ocmd;
oDAdap.Fill(oDtset);

oCon.Close();

}

{

}
}new DataSet();new SqlDataAdapter();new SqlCommand();if (oCon.State == ConnectionState.Closed)"Test";if (oCon.State == ConnectionState.Open)return oDtset;catch (Exception ex)throw new Exception(ex.Message);








object setting = System.Configuration.ConfigurationSettings.AppSettings[key];if (setting != null)if (setting.ToString() == "")null;if (setting != null)String)setting;catch (Exception )"";return defaultValue;throw new Exception("Invalid Connection String. Connection String Should Not Be Empty or Null");catch (Exception)throw;return StatusInfo;
[WebMethod(Description =

{
StatuscodeInfo[] StatusInfo =