//Convert DataTable To List method
public List <GeneralSettingsClass> ConvertToList(DataTable dt)
{
List <GeneralSettingsClass> GeneralSettingslist = new List <GeneralSettingsClass>();
for (int i = 0; i < dt.Rows.Count; i++)
{
GeneralSettingsClass obj_GeneralSettings = new GeneralSettingsClass();
if (Convert.ToString(dt.Rows[i]["Generalsettings"]) != "")
{
obj_GeneralSettings.Generalsettings = Convert.ToInt32(dt.Rows[i]["Generalsettings"]);
}
if (Convert.ToString(dt.Rows[i]["Key"]) != "")
{
obj_GeneralSettings.Key = Convert.ToString(dt.Rows[i]["Key"]);
}
if (Convert.ToString(dt.Rows[i]["Descrpition"]) != "")
{
obj_GeneralSettings.Descrpition = Convert.ToString(dt.Rows[i]["Descrpition"]);
}
GeneralSettingslist.Add(obj_GeneralSettings);
}
return(GeneralSettingslist);
}
//Select Constructor
public GeneralSettingsCtl(Int32?id)
{
obj_con = new ConnectionCls();
GeneralSettingsClass obj_Gen = new GeneralSettingsClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Gen.Generalsettings = Convert.ToInt32(dt.Rows[0]["Generalsettings"]);
obj_Gen.Key = Convert.ToString(dt.Rows[0]["Key"]);
obj_Gen.Descrpition = Convert.ToString(dt.Rows[0]["Descrpition"]);
}
}
}
//insert data into database
public Int32?insert(GeneralSettingsClass obj)
{
try
{
obj_con.clearParameter();
createParameter(obj, DBTrans.Insert);
obj_con.BeginTransaction();
obj_con.ExecuteNoneQuery("sp_GeneralSettings_insert", CommandType.StoredProcedure);
obj_con.CommitTransaction();
return(obj.Generalsettings = Convert.ToInt32(obj_con.getValue("@Generalsettings")));
}
catch (Exception ex)
{
obj_con.RollbackTransaction();
throw new Exception("sp_GeneralSettings_insert:" + ex.Message);
}
}
//update edited object
public GeneralSettingsClass updateObject(GeneralSettingsClass obj)
{
try
{
GeneralSettingsClass oldObj = selectById(obj.Generalsettings);
if (obj.Key == null)
{
obj.Key = oldObj.Key;
}
if (obj.Descrpition == null)
{
obj.Descrpition = oldObj.Descrpition;
}
return(obj);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//create parameter
public void createParameter(GeneralSettingsClass obj, DB_con.DBTrans trans)
{
try
{
obj_con.clearParameter();
if (Convert.ToString(obj.Key) != "")
{
obj_con.addParameter("@Key", string.IsNullOrEmpty(Convert.ToString(obj.Key)) ? "" : obj.Key);
}
else
{
obj_con.addParameter("@Key", DBNull.Value);
}
if (Convert.ToString(obj.Descrpition) != "")
{
obj_con.addParameter("@Descrpition", string.IsNullOrEmpty(Convert.ToString(obj.Descrpition)) ? "" : obj.Descrpition);
}
else
{
obj_con.addParameter("@Descrpition", DBNull.Value);
}
if (Convert.ToString(obj.Generalsettings) != "")
{
obj_con.addParameter("@Generalsettings", Convert.ToInt32(obj.Generalsettings), trans);
}
else
{
obj_con.addParameter("@Generalsettings", DBNull.Value);
}
}
catch (Exception ex)
{
throw ex;
}
}
//Convert DataTable To object method
public GeneralSettingsClass ConvertToOjbect(DataTable dt)
{
GeneralSettingsClass obj_GeneralSettings = new GeneralSettingsClass();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToString(dt.Rows[i]["Generalsettings"]) != "")
{
obj_GeneralSettings.Generalsettings = Convert.ToInt32(dt.Rows[i]["Generalsettings"]);
}
if (Convert.ToString(dt.Rows[i]["Key"]) != "")
{
obj_GeneralSettings.Key = Convert.ToString(dt.Rows[i]["Key"]);
}
if (Convert.ToString(dt.Rows[i]["Descrpition"]) != "")
{
obj_GeneralSettings.Descrpition = Convert.ToString(dt.Rows[i]["Descrpition"]);
}
}
return(obj_GeneralSettings);
}