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