public List <dynamic> AddMembershipRenewalData(MembershipRenewalDetailsDTO memberdata) { string insertProcedure = "[CRUD_RenewalMembership_Master]"; Dictionary <string, string> input_parameters = new Dictionary <string, string>(); input_parameters.Add("@pkey_renewal_receiptId", 1 + "#bigint#" + memberdata.pkey_renewal_receiptId); input_parameters.Add("@member_name", 1 + "#varchar#" + memberdata.member_name); input_parameters.Add("@is_service_tax", 1 + "#bit#" + memberdata.is_service_tax); input_parameters.Add("@date_of_birth", 1 + "#datetime#" + memberdata.date_of_birth); input_parameters.Add("@age", 1 + "#int#" + memberdata.age); input_parameters.Add("@previous_experience", 1 + "#int#" + memberdata.previous_experience); input_parameters.Add("@category", 1 + "#int#" + memberdata.category); input_parameters.Add("@entrance_fee", 1 + "#decimal#" + memberdata.entrance_fee); input_parameters.Add("@amount", 1 + "#decimal#" + memberdata.amount); input_parameters.Add("@paid_by", 1 + "#int#" + memberdata.paid_by); input_parameters.Add("@cheque_no", 1 + "#varchar#" + memberdata.cheque_no); input_parameters.Add("@cheque_date", 1 + "#datetime#" + memberdata.cheque_date); input_parameters.Add("@bank_name", 1 + "#varchar#" + memberdata.bank_name); input_parameters.Add("@receipt_no", 1 + "#bigint#" + memberdata.receipt_no); input_parameters.Add("@GST_NO", 1 + "#nvarchar#" + memberdata.GST_NO); input_parameters.Add("@start_date", 1 + "#datetime#" + memberdata.start_date); input_parameters.Add("@expiry_date", 1 + "#datetime#" + memberdata.expiry_date); input_parameters.Add("@UserID ", 1 + " #bigint# " + memberdata.UserID); input_parameters.Add("@IsDeleted ", 1 + "#int#" + memberdata.is_delete); input_parameters.Add("@Type", 1 + "#int#" + memberdata.Type); input_parameters.Add("@pkey_renewal_receiptIdOut", 2 + "#int#" + null); input_parameters.Add("@ReturnValue", 2 + "#int#" + null); return(obj.SqlCRUD(insertProcedure, input_parameters)); }
public JsonResult AddMembershipRenewalDataDetail(MembershipRenewalDetailsDTO Model) { MembershipRenewalDetailsData memberDetails = new MembershipRenewalDetailsData(); var Data = memberDetails.AddMembershipRenewalData(Model); return(new JsonResult { Data = Data, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }