public static DbStatusEntity[] UpdateData(LedgerMasterEntity obj, int id) //Update data in database
{
var details = new List <DbStatusEntity>();
try
{
details.Add(new LedgerMasterDAO().UpdateLedgerMaster(obj, id));
}
catch (Exception ex)
{
details.Clear();
details.Add(new DbStatusEntity(ex.Message));
}
return(details.ToArray());
}
public static DbStatusEntity[] InsertData(LedgerMasterEntity obj)
{
var details = new List <DbStatusEntity>();
try
{
details.Add(new LedgerMasterDAO().InsertLedgerMaster(obj));
}
catch (Exception ex)
{
details.Clear();
details.Add(new DbStatusEntity(ex.Message));
}
return(details.ToArray());
}
public DbStatusEntity UpdateLedgerMaster(LedgerMasterEntity obj, int id)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_UpdateLedgerMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", id);
cmd.Parameters.AddWithValue("@NAME", obj.NAME);
cmd.Parameters.AddWithValue("@ALIAS_NAME", obj.ALIAS_NAME);
cmd.Parameters.AddWithValue("@LEDGER_TYPE_ID", obj.LEDGER_TYPE_ID);
cmd.Parameters.AddWithValue("@ADDRESS", obj.ADDRESS);
cmd.Parameters.AddWithValue("@CITY", obj.CITY);
cmd.Parameters.AddWithValue("@STATE", obj.STATE);
cmd.Parameters.AddWithValue("@PIN_NO", obj.PIN_NO);
cmd.Parameters.AddWithValue("@MOBILE", obj.MOBILE);
cmd.Parameters.AddWithValue("@TELEPHONE", obj.TELEPHONE);
cmd.Parameters.AddWithValue("@EMAIL", obj.EMAIL);
cmd.Parameters.AddWithValue("@WEB", obj.WEB);
cmd.Parameters.AddWithValue("@GSTIN", obj.GSTIN);
cmd.Parameters.AddWithValue("@REMARKS", obj.REMARKS);
cmd.Parameters.AddWithValue("@ACTIVE_STATUS", obj.ACTIVE_STATUS);
cmd.Parameters.Add("@RESULT", SqlDbType.Int);
cmd.Parameters["@RESULT"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@CNT", SqlDbType.Int);
cmd.Parameters["@CNT"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@MSG", SqlDbType.NVarChar, 500);
cmd.Parameters["@MSG"].Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
objreturn.RESULT = Convert.ToInt32(cmd.Parameters["@RESULT"].Value);
objreturn.CNT = Convert.ToInt32(cmd.Parameters["@CNT"].Value);
objreturn.MSG = Convert.ToString(cmd.Parameters["@MSG"].Value);
con.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(objreturn);
}
public List <LedgerMasterEntity> EditLedgerMaster(int id)
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlDataAdapter adapter;
DataSet ds = new DataSet();
List <LedgerMasterEntity> retlst = new List <LedgerMasterEntity>();
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_GetLedegerDetailsbyID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", id);
con.Open();
adapter = new SqlDataAdapter(cmd);
adapter.Fill(ds);
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
LedgerMasterEntity obj = new LedgerMasterEntity();
obj.ID = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"].ToString());
obj.NAME = ds.Tables[0].Rows[i]["NAME"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["NAME"].ToString();
obj.ALIAS_NAME = ds.Tables[0].Rows[i]["ALIAS_NAME"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["ALIAS_NAME"].ToString();
obj.LEDGER_TYPE_ID = ds.Tables[0].Rows[i]["LEDGER_TYPE_ID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["LEDGER_TYPE_ID"].ToString());
obj.ADDRESS = ds.Tables[0].Rows[i]["ALIAS_NAME"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["ADDRESS"].ToString();
obj.CITY = ds.Tables[0].Rows[i]["CITY"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["CITY"].ToString();
obj.STATE = ds.Tables[0].Rows[i]["STATE"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["STATE"].ToString();
obj.PIN_NO = ds.Tables[0].Rows[i]["PIN_NO"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["PIN_NO"].ToString();
obj.MOBILE = ds.Tables[0].Rows[i]["MOBILE"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["MOBILE"].ToString();
obj.TELEPHONE = ds.Tables[0].Rows[i]["TELEPHONE"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["TELEPHONE"].ToString();
obj.EMAIL = ds.Tables[0].Rows[i]["EMAIL"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["EMAIL"].ToString();
obj.WEB = ds.Tables[0].Rows[i]["ALIAS_NAME"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["WEB"].ToString();
obj.GSTIN = ds.Tables[0].Rows[i]["GSTIN"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["GSTIN"].ToString();
obj.REMARKS = ds.Tables[0].Rows[i]["REMARKS"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["REMARKS"].ToString();
obj.ACTIVE_STATUS = ds.Tables[0].Rows[i]["ACTIVE_STATUS"] == DBNull.Value ? true : Convert.ToBoolean(ds.Tables[0].Rows[i]["ACTIVE_STATUS"]);
retlst.Add(obj);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retlst);
}
public List <LedgerMasterEntity> GetLedgerMasterList()
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlDataAdapter adapter;
DataSet ds = new DataSet();
List <LedgerMasterEntity> retlst = new List <LedgerMasterEntity>();
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_GetLedgerMasterList", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
adapter = new SqlDataAdapter(cmd);
adapter.Fill(ds);
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
LedgerMasterEntity obj = new LedgerMasterEntity();
obj.ID = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"].ToString());
obj.NAME = ds.Tables[0].Rows[i]["NAME"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["NAME"].ToString();
obj.ALIAS_NAME = ds.Tables[0].Rows[i]["ALIAS_NAME"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["ALIAS_NAME"].ToString();
obj.LEDGER_TYPE = ds.Tables[0].Rows[i]["LEDGER_TYPE"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["LEDGER_TYPE"].ToString();
obj.CITY = ds.Tables[0].Rows[i]["CITY"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["CITY"].ToString();
obj.MOBILE = ds.Tables[0].Rows[i]["MOBILE"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["MOBILE"].ToString();
obj.ACTIVE_STATUS = ds.Tables[0].Rows[i]["ACTIVE_STATUS"] == DBNull.Value ? true : Convert.ToBoolean(ds.Tables[0].Rows[i]["ACTIVE_STATUS"]);
retlst.Add(obj);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retlst);
}
