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