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); }