public DbStatusEntity GetFogotPassword(string email)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_GetForgotPasswordDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EMAIL", email);
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 DbStatusEntity ChangePassword(ChangePasswordEntity obj)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_UpdateNewPassword", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@USER_ID", obj.USER_ID);
cmd.Parameters.AddWithValue("@OLD_PASSWORD", CryptographyHelper.Instance.Encrypt(obj.OLD_PASSWORD));
cmd.Parameters.AddWithValue("@NEW_PASSWORD", CryptographyHelper.Instance.Encrypt(obj.NEW_PASSWORD));
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 DbStatusEntity DeleteTaskStageMaster(int id)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand(TaskMasterQueries.DeleteTaskStageMaster, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", id);
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 DbStatusEntity UpdateCatalogImagesStatus(long id, string phy_file_name)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_UpdateCatalogImageStatus", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", id);
cmd.Parameters.AddWithValue("@PHY_FILE_NAME", phy_file_name);
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 DbStatusEntity UpdateOccasion(OccasionMasterEntity 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_UpdateOccasionMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", id);
cmd.Parameters.AddWithValue("@NAME", obj.NAME);
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 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 DbStatusEntity UpdateClientCredentials(ClientCredentialsEntity obj)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_UpdateClientCredentials", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", obj.ID);
cmd.Parameters.AddWithValue("@CLIENT_ID", obj.CLIENT_ID);
cmd.Parameters.AddWithValue("@SITE_NAME", obj.SITE_NAME);
cmd.Parameters.AddWithValue("@URL", obj.URL);
cmd.Parameters.AddWithValue("@UNAME", obj.UNAME);
cmd.Parameters.AddWithValue("@UPASS", obj.UPASS);
cmd.Parameters.AddWithValue("@REMARKS", obj.REMARKS);
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 DbStatusEntity UpdateUserMaster(UserMasterEntity 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_UpdateUsersMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@USER_ID", id);
cmd.Parameters.AddWithValue("@USER_PASSWORD", CryptographyHelper.Instance.Encrypt(obj.USER_PASSWORD));
cmd.Parameters.AddWithValue("@NAME", obj.NAME);
cmd.Parameters.AddWithValue("@EMAIL", obj.EMAIL);
cmd.Parameters.AddWithValue("@MOBILE_NO", obj.MOBILE_NO);
cmd.Parameters.AddWithValue("@ACTIVE_STATUS", obj.ACTIVE_STATUS);
cmd.Parameters.AddWithValue("@ROLE_ID", obj.ROLE_ID);
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 DbStatusEntity InsertBanner(BannerImageEntity obj)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_InsertBannerMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HEADING", obj.HEADING);
cmd.Parameters.AddWithValue("@DESCRIPTION", obj.DESCRIPTION);
cmd.Parameters.AddWithValue("@ORG_FILE_NAME", obj.ORG_FILE_NAME);
cmd.Parameters.AddWithValue("@PHY_FILE_NAME", obj.PHY_FILE_NAME);
cmd.Parameters.AddWithValue("@FCOLOR", obj.FCOLOR);
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 DbStatusEntity InsertTaskAbortTrn(Int64 T_ID, Int64 C_ID, string SCH_ON, Int64 userid)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_InsertTaskAbortTrn", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@C_ID", C_ID);
cmd.Parameters.AddWithValue("@TM_ID", T_ID);
cmd.Parameters.AddWithValue("@SCH_ON", SCH_ON);
cmd.Parameters.AddWithValue("@USER_ID", userid);
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 DbStatusEntity InsertBarcode(Int64 id, string genid)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
DataSet ds = new DataSet();
List <JewelleryMasterEntity> retlst = new List <JewelleryMasterEntity>();
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_InsertBarcode", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CATALOG_ID", id);
cmd.Parameters.AddWithValue("@GENID", genid);
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 DbStatusEntity UpdateRolesMenu(List <RoleSelectedMenuEntity> 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_UpdateRolesMenu", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", id);
SqlParameter sqlParam = cmd.Parameters.AddWithValue("@TVP", CreateDataTable(obj));
sqlParam.SqlDbType = SqlDbType.Structured;
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 DbStatusEntity InsertCatalog(CatalogMasterEntity obj)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_InsertCatalogMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CODE", obj.CODE);
cmd.Parameters.AddWithValue("@TITLE", obj.TITLE);
cmd.Parameters.AddWithValue("@REMARKS", obj.REMARKS);
cmd.Parameters.AddWithValue("@ACTIVE_STATUS", obj.ACTIVE_STATUS);
cmd.Parameters.AddWithValue("@SHOW_CATALOG", obj.SHOW_CATALOG);
cmd.Parameters.AddWithValue("@SHOW_TRENDING", obj.SHOW_TRENDING);
cmd.Parameters.AddWithValue("@JEWELLERY_ID", obj.JEWELLERY_ID);
cmd.Parameters.AddWithValue("@DESIGN_ID", obj.DESIGN_ID);
cmd.Parameters.AddWithValue("@COLLECTIONS_ID", obj.COLLECTIONS_ID);
cmd.Parameters.AddWithValue("@MATERIAL_ID", obj.MATERIAL_ID);
cmd.Parameters.AddWithValue("@OCCASION_ID", obj.OCCASION_ID);
cmd.Parameters.AddWithValue("@GRAMSLAB_ID", obj.GRAMSLAB_ID);
cmd.Parameters.AddWithValue("@KARAT_ID", obj.KARAT_ID);
cmd.Parameters.AddWithValue("@PURITY", obj.PURITY);
cmd.Parameters.AddWithValue("@RATE", obj.RATE);
cmd.Parameters.AddWithValue("@GR_WT", obj.GR_WT);
cmd.Parameters.AddWithValue("@ST_WT", obj.ST_WT);
cmd.Parameters.AddWithValue("@NET_WT", obj.NET_WT);
cmd.Parameters.AddWithValue("@VA_PER", obj.VA_PER);
cmd.Parameters.AddWithValue("@VA_AMT", obj.VA_AMT);
cmd.Parameters.AddWithValue("@ST_AMT", obj.ST_AMT);
cmd.Parameters.AddWithValue("@TAXABLE_AMT", obj.TAXABLE_AMT);
cmd.Parameters.AddWithValue("@TAX_PER", obj.TAX_PER);
cmd.Parameters.AddWithValue("@TAX_AMT", obj.TAX_AMT);
cmd.Parameters.AddWithValue("@NET_AMT", obj.NET_AMT);
cmd.Parameters.AddWithValue("@S_PER", obj.S_PER);
cmd.Parameters.AddWithValue("@DATE_YM", obj.DATE_YM);
cmd.Parameters.AddWithValue("@LED_NAME", obj.LED_NAME);
cmd.Parameters.AddWithValue("@DIA_CARAT", obj.DIA_CARAT);
cmd.Parameters.AddWithValue("@PCS", obj.PCS);
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 DbStatusEntity InsertStockEntry(StockEntryInsertParam1 obj, StockEntryInsertParam2[] obj2, Int64 userid)
{
DataTable dtsub = new DataTable();
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
dtsub.Columns.Add("CATALOG_ID", typeof(Int64));
dtsub.Columns.Add("SKU", typeof(string));
dtsub.Columns.Add("CODE", typeof(string));
dtsub.Columns.Add("CATALOG_TITLE", typeof(string));
dtsub.Columns.Add("QTY", typeof(double));
dtsub.Columns.Add("REMARKS", typeof(string));
dtsub.Columns.Add("GENID", typeof(string));
foreach (StockEntryInsertParam2 ob in obj2)
{
DataRow dr = dtsub.NewRow();
dr["CATALOG_ID"] = ob.ID;
dr["SKU"] = ob.SKU;
dr["CODE"] = ob.CODE;
dr["CATALOG_TITLE"] = ob.TITLE;
dr["QTY"] = ob.QTY;
dr["REMARKS"] = ob.REMARKS;
dr["GENID"] = ob.GENID;
dtsub.Rows.Add(dr);
}
dtsub.AcceptChanges();
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_InsertStockEntry", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@LED_NAME", obj.LED_NAME);
cmd.Parameters.AddWithValue("@TRANS_DATE", obj.TRANS_DATE);
cmd.Parameters.AddWithValue("@REF_NO", obj.REF_NO);
cmd.Parameters.AddWithValue("@REMARKS", obj.REMARKS);
cmd.Parameters.AddWithValue("@USER_ID", userid);
SqlParameter sqlParam = cmd.Parameters.AddWithValue("@TVP", dtsub);
sqlParam.SqlDbType = SqlDbType.Structured;
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 DbStatusEntity UpdateBill(BillParamEntity obj, Int64 id)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_UpdateBill", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BILL_ID", id);
cmd.Parameters.AddWithValue("@C_ID", obj.C_ID);
cmd.Parameters.AddWithValue("@C_NO", obj.C_NO);
cmd.Parameters.AddWithValue("@FILE_NO", obj.FILE_NO);
cmd.Parameters.AddWithValue("@C_NAME", obj.C_NAME);
cmd.Parameters.AddWithValue("@BILL_DATE", obj.BILL_DATE);
cmd.Parameters.AddWithValue("@DUE_DATE", obj.DUE_DATE);
cmd.Parameters.AddWithValue("@PAYMODE_ID", obj.PAYMODE_ID);
cmd.Parameters.AddWithValue("@PAYMODE_NAME", obj.PAYMODE_NAME);
cmd.Parameters.AddWithValue("@TASK_ID", obj.TASK_ID);
cmd.Parameters.AddWithValue("@TASK_NO", obj.TASK_NO);
cmd.Parameters.AddWithValue("@GROSS_AMT", obj.GROSS_AMT);
cmd.Parameters.AddWithValue("@SGST_AMT", obj.SGST_AMT);
cmd.Parameters.AddWithValue("@CGST_AMT", obj.CGST_AMT);
cmd.Parameters.AddWithValue("@IGST_AMT", obj.IGST_AMT);
cmd.Parameters.AddWithValue("@OTH_AMT", obj.OTH_AMT);
cmd.Parameters.AddWithValue("@NET_AMT", obj.NET_AMT);
cmd.Parameters.AddWithValue("@REMARKS", obj.REMARKS);
DataTable dtsub = new DataTable();
dtsub.Columns.Add("SL_NO", typeof(int));
dtsub.Columns.Add("DESCP", typeof(string));
dtsub.Columns.Add("GROSS_AMT", typeof(Double));
dtsub.Columns.Add("SGST_PER", typeof(Double));
dtsub.Columns.Add("SGST_AMT", typeof(Double));
dtsub.Columns.Add("CGST_PER", typeof(Double));
dtsub.Columns.Add("CGST_AMT", typeof(Double));
dtsub.Columns.Add("IGST_PER", typeof(Double));
dtsub.Columns.Add("IGST_AMT", typeof(Double));
dtsub.Columns.Add("NET_AMT", typeof(Double));
dtsub.Columns.Add("REMARKS", typeof(string));
foreach (BillSubEntity objsub in obj.SUBARRAY)
{
DataRow dr = dtsub.NewRow();
dr["SL_NO"] = objsub.SL_NO;
dr["DESCP"] = objsub.DESCP;
dr["GROSS_AMT"] = objsub.GROSS_AMT;
dr["SGST_PER"] = objsub.SGST_PER;
dr["SGST_AMT"] = objsub.SGST_AMT;
dr["CGST_PER"] = objsub.CGST_PER;
dr["CGST_AMT"] = objsub.CGST_AMT;
dr["IGST_PER"] = objsub.IGST_PER;
dr["IGST_AMT"] = objsub.IGST_AMT;
dr["NET_AMT"] = objsub.NET_AMT;
dr["REMARKS"] = objsub.REMARKS;
dtsub.Rows.Add(dr);
}
SqlParameter sqlParam = cmd.Parameters.AddWithValue("@TVP", dtsub);
sqlParam.SqlDbType = SqlDbType.Structured;
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 DbStatusEntity InsertClient(ClientMasterEntity obj)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_InsertClientMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FILE_NO", obj.FILE_NO);
cmd.Parameters.AddWithValue("@C_NAME", obj.C_NAME);
cmd.Parameters.AddWithValue("@ALIAS", obj.ALIAS);
cmd.Parameters.AddWithValue("@FNAME", obj.FNAME);
cmd.Parameters.AddWithValue("@HNAME", obj.HNAME);
cmd.Parameters.AddWithValue("@GENDER", obj.GENDER);
cmd.Parameters.AddWithValue("@SAME_AB", obj.SAME_AB);
cmd.Parameters.AddWithValue("@ADDR", obj.ADDR);
cmd.Parameters.AddWithValue("@ADDR1", obj.ADDR1);
cmd.Parameters.AddWithValue("@CITY", obj.CITY);
cmd.Parameters.AddWithValue("@CITY1", obj.CITY1);
cmd.Parameters.AddWithValue("@PIN", obj.PIN);
cmd.Parameters.AddWithValue("@PIN1", obj.PIN1);
cmd.Parameters.AddWithValue("@STATE", obj.STATE);
cmd.Parameters.AddWithValue("@STATE1", obj.STATE1);
cmd.Parameters.AddWithValue("@CNT_NAME", obj.CNT_NAME);
cmd.Parameters.AddWithValue("@PH_NO", obj.PH_NO);
cmd.Parameters.AddWithValue("@MOBILE_NO1", obj.MOBILE_NO1);
cmd.Parameters.AddWithValue("@MOBILE_NO2", obj.MOBILE_NO2);
cmd.Parameters.AddWithValue("@EMAIL_ID", obj.EMAIL_ID);
cmd.Parameters.AddWithValue("@DOB", obj.DOB);
cmd.Parameters.AddWithValue("@PAN", obj.PAN);
cmd.Parameters.AddWithValue("@AADHAAR", obj.AADHAAR);
cmd.Parameters.AddWithValue("@GSTIN", obj.GSTIN);
cmd.Parameters.AddWithValue("@WARD", obj.WARD);
cmd.Parameters.AddWithValue("@RACK_NO", obj.RACK_NO);
cmd.Parameters.AddWithValue("@CLI_GRP_ID", obj.CLI_GRP_ID);
cmd.Parameters.AddWithValue("@Alert_Msg", obj.ALERT_MSG);
cmd.Parameters.AddWithValue("@ClientCategoryStringList", obj.ClientCategoryStringList);
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 DbStatusEntity UpdateTaskMaster(TaskMasterParamEntity obj, Int64 id)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_UpdateTaskMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@T_ID", id);
cmd.Parameters.AddWithValue("@T_NAME", obj.T_NAME);
cmd.Parameters.AddWithValue("@T_DESC", obj.T_DESC);
cmd.Parameters.AddWithValue("@PRIORITY", obj.PRIORITY);
cmd.Parameters.AddWithValue("@RECURRING_TYPE", obj.RECURRING_TYPE);
cmd.Parameters.AddWithValue("@RECURRING_DAYS", obj.RECURRING_DAYS);
cmd.Parameters.AddWithValue("@RECURRING_START_DAY", obj.RECURRING_START_DAY);
cmd.Parameters.AddWithValue("@RECURRING_START_DATE", obj.RECURRING_START_DATE);
cmd.Parameters.AddWithValue("@RECURRING_END_DATE", obj.RECURRING_END_DATE);
cmd.Parameters.AddWithValue("@ACTIVE_STATUS", obj.ACTIVE_STATUS);
cmd.Parameters.AddWithValue("@MAPPED_CLIENTS", obj.MAPPED_CLIENTS);
cmd.Parameters.AddWithValue("@MAPPED_CLI_CAT", obj.MAPPED_CLI_CAT);
DataTable dtsub = new DataTable();
dtsub.Columns.Add("TS_ID", typeof(int));
dtsub.Columns.Add("TS_NAME", typeof(string));
dtsub.Columns.Add("USER_ID", typeof(int));
dtsub.Columns.Add("SL_NO", typeof(int));
foreach (TaskMasterSubParamEntity objsub in obj.SUBARR)
{
DataRow dr = dtsub.NewRow();
dr["TS_ID"] = 0;
dr["TS_NAME"] = objsub.STAGE;
dr["USER_ID"] = objsub.USER_ID;
dr["SL_NO"] = objsub.SLNO;
dtsub.Rows.Add(dr);
}
SqlParameter sqlParam = cmd.Parameters.AddWithValue("@TVP", dtsub);
sqlParam.SqlDbType = SqlDbType.Structured;
DataTable dtdocs = new DataTable();
dtdocs.Columns.Add("SL_NO", typeof(int));
dtdocs.Columns.Add("DOC_NAME", typeof(string));
foreach (TaskDocumentEntity objdoc in obj.DOCARR)
{
DataRow dr = dtdocs.NewRow();
dr["SL_NO"] = objdoc.SL_NO;
dr["DOC_NAME"] = objdoc.DOC_NAME;
dtdocs.Rows.Add(dr);
}
SqlParameter sqlParamdoc = cmd.Parameters.AddWithValue("@TVPDOCS", dtdocs);
sqlParamdoc.SqlDbType = SqlDbType.Structured;
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 DbStatusEntity InsertBS(BSParamEntity obj)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_InsertBillSettlement", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@C_ID", obj.C_ID);
cmd.Parameters.AddWithValue("@C_NO", obj.C_NO);
cmd.Parameters.AddWithValue("@FILE_NO", obj.FILE_NO);
cmd.Parameters.AddWithValue("@C_NAME", obj.C_NAME);
cmd.Parameters.AddWithValue("@BS_DATE", obj.BS_DATE);
cmd.Parameters.AddWithValue("@PAYMODE_ID", obj.PAYMODE_ID);
cmd.Parameters.AddWithValue("@PAYMODE_NAME", obj.PAYMODE_NAME);
cmd.Parameters.AddWithValue("@BS_AMT", obj.BS_AMT);
cmd.Parameters.AddWithValue("@REMARKS", obj.REMARKS);
DataTable dtsub = new DataTable();
dtsub.Columns.Add("SL_NO", typeof(int));
dtsub.Columns.Add("BILL_ID", typeof(int));
dtsub.Columns.Add("BILL_NO", typeof(int));
dtsub.Columns.Add("BILL_DATE", typeof(string));
dtsub.Columns.Add("BILL_AMT", typeof(Double));
dtsub.Columns.Add("PAID_AMT", typeof(Double));
dtsub.Columns.Add("BAL_AMT", typeof(Double));
dtsub.Columns.Add("BS_AMT", typeof(Double));
foreach (BSsubEntity objsub in obj.SUBARRAY)
{
if (objsub.BS_AMT > 0)
{
DataRow dr = dtsub.NewRow();
dr["SL_NO"] = objsub.SL_NO;
dr["BILL_ID"] = objsub.BILL_ID;
dr["BILL_NO"] = objsub.BILL_NO;
dr["BILL_DATE"] = objsub.BILL_DATE;
dr["BILL_AMT"] = objsub.BILL_AMT;
dr["PAID_AMT"] = objsub.PAID_AMT;
dr["BAL_AMT"] = objsub.BAL_AMT;
dr["BS_AMT"] = objsub.BS_AMT;
dtsub.Rows.Add(dr);
}
}
SqlParameter sqlParam = cmd.Parameters.AddWithValue("@TVP", dtsub);
sqlParam.SqlDbType = SqlDbType.Structured;
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);
}