private void GetFinaceDetail() { try { Datefunc(); SqlConnection conn = null; DataTable dt = new DataTable(); using (conn = dbaccess.GetConnection()) { SqlCommand sqlCmd = new SqlCommand("[dbo].[Report_BankpaymentFinalFinanceDetail]"); sqlCmd.Connection = conn; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@spccode", ccode); sqlCmd.Parameters.AddWithValue("@sppcode", pcode); sqlCmd.Parameters.AddWithValue("@spfrmdate", d1.ToString().Trim()); sqlCmd.Parameters.AddWithValue("@sptodate", d2.ToString().Trim()); SqlDataAdapter adp = new SqlDataAdapter(sqlCmd); adp.Fill(dt); FinanceDetails.DataSource = dt; FinanceDetails.DataBind(); } } catch (Exception ex) { Lbl_Errormsg.Visible = true; Lbl_Errormsg.Text = ex.ToString(); } }
public HttpResponseMessage Post(FinanceDetails message) { if (message == null || !ModelState.IsValid) { return(Request.CreateErrorResponse( HttpStatusCode.BadRequest, "Invalid input")); } messages.Add(message); return(Request.CreateResponse(HttpStatusCode.Created)); }
public long AddCompanyFinanceDetails(FinanceDetails obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Customer_Code", obj.Customer_Code), new SqlParameter("@Bank_Guaranty_Amount", obj.Bank_Guaranty_Amount), new SqlParameter("@Guaranty_Bank", obj.Guaranty_Bank), new SqlParameter("@Branch", obj.Branch), new SqlParameter("@Bank_Guaranty_Exceed_Pre", obj.Bank_Guaranty_Exceed_Pre), new SqlParameter("@Renew_Date", obj.Renew_Date), new SqlParameter("@Remaing_Dates", obj.Remaing_Dates), new SqlParameter("@Status", obj.Status), new SqlParameter("@UserID", obj.UserID) }; return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_NewCustomerFinanceDetails", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public Login(LoginInfo loginInfo, PropertyDetails propertyDetails, FinanceDetails financeDetails) { LoginInfo = loginInfo; PropertyDetails = propertyDetails; FinanceDetails = financeDetails; }