public static DbStatusEntity[] InsertData(BSParamEntity obj)
{
var details = new List <DbStatusEntity>();
try
{
details.Add(new BSDAO().InsertBS(obj));
}
catch (Exception ex)
{
details.Clear();
details.Add(new DbStatusEntity(ex.Message));
}
return(details.ToArray());
}
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);
}
