public List <dynamic> AddBranches(BranchDetailsUI Branches) { string insertProcedure = "[CRUD_BranchMaster]"; Dictionary <string, string> input_parameters = new Dictionary <string, string>(); // input_parameters.Add("@Pkey_Branch_id", 1 + "#bigint#" + Branches.BranchId); input_parameters.Add("@Pkey_Branch_id", 1 + "#bigint#" + Branches.Pkey_Branch_id); input_parameters.Add("@Branch_name", 1 + "#varchar#" + Branches.Branch_name); input_parameters.Add("@BranchEmailId", 1 + "#varchar#" + Branches.BranchEmailId); input_parameters.Add("@address1", 1 + "#varchar#" + Branches.address1); input_parameters.Add("@address2", 1 + "#varchar#" + Branches.address2); input_parameters.Add("@phoneno", 1 + "#bigint#" + Branches.phoneno); input_parameters.Add("@city", 1 + "#int#" + Branches.city); input_parameters.Add("@state", 1 + "#int#" + Branches.state); input_parameters.Add("@country", 1 + "#int#" + Branches.country); input_parameters.Add("@pincode", 1 + "#int#" + Branches.pincode); input_parameters.Add("@UserID", 1 + "#int#" + Branches.UserID); input_parameters.Add("@is_delete", 1 + "#int#" + Branches.is_delete); input_parameters.Add("@Type", 1 + "#int#" + Branches.Type); input_parameters.Add("@Pkey_Branch_idout", 2 + "#int#" + null); input_parameters.Add("@ReturnValue", 2 + "#int#" + null); return(obj.SqlCRUD(insertProcedure, input_parameters)); }
public List <dynamic> GetBranchDataByID(BranchDetailsUI branchdata) { List <dynamic> objDynamic = new List <dynamic>(); string insertProcedure = "[Get_BranchMasterByID]"; Dictionary <string, string> input_parameters = new Dictionary <string, string>(); input_parameters.Add("@Pkey_Branch_id", 1 + "#bigint#" + branchdata.BranchId); DataSet ds = obj.SelectSql(insertProcedure, input_parameters); var myEnumerable = ds.Tables[0].AsEnumerable(); List <BranchDetailsUI> ordtl = (from item in myEnumerable select new BranchDetailsUI { BranchName = item.Field <String>("Branch_name"), Address1 = item.Field <String>("address1"), Address2 = item.Field <String>("address2"), FullAddress = item.Field <String>("address3"), Zip = item.Field <int>("pincode"), City = item.Field <int>("city"), State = item.Field <int>("state"), country = item.Field <int>("country"), }).ToList(); objDynamic.Add(ordtl); return(objDynamic); }
//get branch data by id public JsonResult GetBranchDetailData(BranchDetailsUI branchDetailsUI) { BranchDetailsData branchDetailsData = new BranchDetailsData(); var Data = branchDetailsData.GetBranchDataByID(branchDetailsUI); return(new JsonResult { Data = Data, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
//add batch data public JsonResult AddNewBrach(BranchDetailsUI Model) { BranchDetailsData obj = new BranchDetailsData(); var Data = obj.AddBranches(Model); //var Data = RepoData.AddBranches(Model); return(new JsonResult { Data = Data, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
//branches insert public List <dynamic> AddBranches(BranchDetailsUI Branches) { List <dynamic> ObjDynamic = new List <dynamic>(); BranchDetailsDTO BranchDTO = new BranchDetailsDTO(); BranchDTO.BranchId = Branches.BranchId; BranchDTO.BranchName = Branches.BranchName; BranchDTO.City = Branches.City; BranchDTO.FullAddress = Branches.FullAddress; BranchDTO.State = Branches.State; BranchDTO.Zip = Branches.Zip; BranchDTO.country = Branches.country; BranchDTO.UserID = Branches.UserID; BranchDTO.Type = 1; AddBranches(BranchDTO); ObjDynamic.Add(BranchDTO); return(ObjDynamic); }
public List <dynamic> GetBranchDataByID(BranchDetailsUI branchdata) { List <dynamic> objDynamic = new List <dynamic>(); string insertProcedure = "[Get_BranchMasterByID]"; Dictionary <string, string> input_parameters = new Dictionary <string, string>(); input_parameters.Add("@branch_id", 1 + "#bigint#" + branchdata.Pkey_Branch_id); DataSet ds = obj.SelectSql(insertProcedure, input_parameters); var myEnumerable = ds.Tables[0].AsEnumerable(); try { List <BranchDetailsUI> ordtl = (from item in myEnumerable select new BranchDetailsUI { Pkey_Branch_id = item.Field <Int64>("Pkey_Branch_id"), Branch_name = item.Field <String>("Branch_name"), address1 = item.Field <String>("address1"), address2 = item.Field <String>("address2"), BranchEmailId = item.Field <String>("BranchEmailId"), phoneno = item.Field <Int64?>("phoneno"), pincode = item.Field <int?>("pincode"), city = item.Field <int?>("city"), state = item.Field <int?>("state"), country = item.Field <int?>("country"), city_name = item.Field <String>("city_name"), state_name = item.Field <String>("state_name"), }).ToList(); objDynamic.Add(ordtl); } catch (Exception ex) { Console.Write("invalid"); } return(objDynamic); }