public static DbStatusEntity[] InsertData(BillParamEntity obj)
{
var details = new List <DbStatusEntity>();
try
{
details.Add(new BillDAO().InsertBill(obj));
}
catch (Exception ex)
{
details.Clear();
details.Add(new DbStatusEntity(ex.Message));
}
return(details.ToArray());
}
public static DbStatusEntity[] UpdateData(BillParamEntity obj, Int64 id) //Update data in database
{
var details = new List <DbStatusEntity>();
try
{
details.Add(new BillDAO().UpdateBill(obj, id));
}
catch (Exception ex)
{
details.Clear();
details.Add(new DbStatusEntity(ex.Message));
}
return(details.ToArray());
}
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);
}
