public JsonResult AddMemberFeeDetail(MemberfeeDetailsDTO memberfeeDetailsDTO)
{
MemberfeeDetailsData memberfeeDetails = new MemberfeeDetailsData();
var Data = memberfeeDetails.AddMemberfeeDetail(memberfeeDetailsDTO);
return(new JsonResult {
Data = Data, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public List <dynamic> AddMemberfeeDetail(MemberfeeDetailsDTO memberfeeDetailsDTO)
{
string insertProcedure = "[CRUD_MemberFee_Master]";
Dictionary <string, string> input_parameters = new Dictionary <string, string>();
input_parameters.Add("@pkey_memberFee_id", 1 + "#bigint#" + memberfeeDetailsDTO.pkey_memberFee_id);
input_parameters.Add("@categoryId", 1 + "#bigint#" + memberfeeDetailsDTO.categoryId);
input_parameters.Add("@entrance_fee", 1 + "#decimal#" + memberfeeDetailsDTO.entrance_fee);
input_parameters.Add("@infrastructure_fee", 1 + "#decimal#" + memberfeeDetailsDTO.infrastructure_fee);
input_parameters.Add("@Admission_fee", 1 + "#decimal#" + memberfeeDetailsDTO.Admission_fee);
input_parameters.Add("@total", 1 + "#decimal#" + memberfeeDetailsDTO.total);
input_parameters.Add("@UserID ", 1 + " #bigint# " + memberfeeDetailsDTO.UserID);
input_parameters.Add("@IsDeleted ", 1 + "#int#" + memberfeeDetailsDTO.is_delete);
input_parameters.Add("@Type", 1 + "#int#" + memberfeeDetailsDTO.Type);
input_parameters.Add("@pkey_memberFee_idOut", 2 + "#int#" + null);
input_parameters.Add("@ReturnValue", 2 + "#int#" + null);
return(obj.SqlCRUD(insertProcedure, input_parameters));
}