public GenericResponse <List <CityContract> > getAllCities(BranchRequest request)
{
Business.Banking.City cityBusiness = new Business.Banking.City();
var response = cityBusiness.getAllCities();
return(response);
}
public GenericResponse <BranchContract> AddNewBranch(BranchRequest request)
{
request.DataContract.DateOfLaunch = DateTime.Now;
DbOperation dbOperation = new DbOperation();
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@BranchName", request.DataContract.BranchName),
new SqlParameter("@Adress", request.DataContract.Adress),
new SqlParameter("@CityId", request.DataContract.CityId),
new SqlParameter("@DateOfLaunch", request.DataContract.DateOfLaunch),
new SqlParameter("@MailAdress", request.DataContract.MailAdress),
new SqlParameter("@PhoneNumber", request.DataContract.PhoneNumber),
};
try
{
var dbResponse = Convert.ToInt32(dbOperation.spExecuteScalar("COR.ins_AddNewBranch", parameters));
return(new GenericResponse <BranchContract>()
{
IsSuccess = true
});
}
catch (Exception)
{
return(new GenericResponse <BranchContract>()
{
ErrorMessage = "AddNewBranch fonksiyonu başarısız", IsSuccess = false
});
//throw;
}
}
/// <summary>
/// 初始化出库edit框
/// </summary>
/// <returns></returns>
public ActionResult Create()
{
var OrderList = this.StoreService.GetOrderList(new OrderRequest());
this.ViewBag.OrderType = new SelectList(OrderList, "dt_id", "name");
//获取组织机构列表（领用人）
BranchRequest brequest = new BranchRequest();
brequest.PageSize = 10000;
var lyr = this.OAService.GetBranchList(brequest);
List <string> clmcs = new List <string>();
clmcs.Add("请选择领用人...");
foreach (Branch branchItem in lyr)
{
clmcs.Add(branchItem.Name);
}
this.ViewBag.employment = new SelectList(clmcs);
var model = new StoreTable();
return(View("OutBoundEdit", model));
}
public GenericResponse <BranchContract> UpdateBranchDetailsById(BranchRequest request)
{
DbOperation dbOperation = new DbOperation();
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("Id", request.DataContract.Id),
new SqlParameter("@BranchName", request.DataContract.BranchName),
new SqlParameter("@Adress", request.DataContract.Adress),
new SqlParameter("CityId", request.DataContract.CityId),
new SqlParameter("MailAdress", request.DataContract.MailAdress),
new SqlParameter("PhoneNumber", request.DataContract.PhoneNumber)
};
try
{
var dbResponse = dbOperation.spExecuteScalar("COR.upd_UpdateBranchDetailsById", parameters);
return(new GenericResponse <BranchContract>()
{
IsSuccess = true
});
}
catch (Exception)
{
return(new GenericResponse <BranchContract>()
{
ErrorMessage = "UpdateBranchDetailsById fonksiyonu başarısız", IsSuccess = false
});
}
}
public GenericResponse <BranchContract> DeleteBranchById(BranchRequest request)
{
DbOperation dbOperation = new DbOperation();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@BranchId", request.DataContract.Id),
};
try
{
var dbResponse = dbOperation.spExecuteScalar("COR.del_BranchDeleteById", parameters);
return(new GenericResponse <BranchContract>()
{
IsSuccess = true
});
}
catch (Exception)
{
return(new GenericResponse <BranchContract>()
{
ErrorMessage = "DeleteBranchById işlemi başarısız oldu!", IsSuccess = false
});
//throw;
}
}
public GenericResponse <BranchContract> DeleteBranchById(BranchRequest request)
{
Business.Banking.Branch branchBusiness = new Business.Banking.Branch();
var response = branchBusiness.DeleteBranchById(request);
return(response);
}
public GenericResponse <List <BranchContract> > GetAllBranches(BranchRequest request)
{
Business.Banking.Branch branchBusiness = new Business.Banking.Branch();
var response = branchBusiness.GetAllBranches(request);
return(response);
}
public GenericResponse <BranchContract> AddNewBranch(BranchRequest request)
{
Business.Banking.Branch branchBusiness = new Business.Banking.Branch();
var response = branchBusiness.AddNewBranch(request);
return(response);
}
public GenericResponse <List <BranchContract> > FilterBranchsByProperties(BranchRequest request)
{
if (request.DataContract.DateOfLaunch.GetValueOrDefault() < new DateTime(1753, 01, 01))
{
DateTime sqlRange = new DateTime(1753, 01, 01);
request.DataContract.DateOfLaunch = sqlRange;
}
Business.Banking.Branch branchBusiness = new Business.Banking.Branch();
var response = branchBusiness.FilterBranchsByProperties(request);
return(response);
}
public CreateResponse Create(BranchRequest request)
{
try
{
var branch = TypeAdapter.Adapt <Branch>(request);
_branchValidator.ValidateAndThrowException(branch, "Base,Create");
_branchRepository.Add(branch);
return(new CreateResponse(branch.Id));
}
catch (DataAccessException)
{
throw new ApplicationException();
}
}
public async Task CreateRepositoryBranch(
string userAgent,
string authorizationToken,
string repositoryName,
string masterBranchName,
string newBranchName)
{
HttpClient httpClient = new HttpClient {
BaseAddress = new Uri(ApiBaseUri)
};
this.SetRequestHeaders(httpClient.DefaultRequestHeaders, userAgent, authorizationToken, null);
var requestUri = string.Format(@"repos/{0}/{1}/git/refs", userAgent, repositoryName);
var sha = await this.GetSha(
userAgent,
authorizationToken,
repositoryName,
masterBranchName).ConfigureAwait(false);
var branchRequest = new BranchRequest
{
Ref = string.Format(@"refs/heads/{0}", newBranchName),
Sha = sha,
};
HttpResponseMessage response = await httpClient.PostAsJsonAsync(requestUri, branchRequest).ConfigureAwait(false);
if (response.IsSuccessStatusCode)
{
return;
}
if (Convert.ToInt32(response.StatusCode) == 422)
{
var error = await response.Content.ReadAsJsonAsync <ErrorResponseDto>().ConfigureAwait(false);
if (error.Message == MessagesResponse.ReferenceAlreadyExists)
{
return;
}
}
var exception = new HttpRequestException(string.Format(@"Response bad satus code: {0}", response.StatusCode));
exception.Data.Add("response", response);
throw exception;
}
private List <BranchContract> GetAllBranchs()
{
var connect = new Connector.Banking.Connect <GenericResponse <List <BranchContract> > >();
var request = new BranchRequest();
request.MethodName = "GetAllBranches";
var response = connect.Execute(request);
if (!response.IsSuccess)
{
MessageBox.Show($"{response.ErrorMessage}", "Hata", MessageBoxButton.OK, MessageBoxImage.Error);
return(null);
}
return(response.Value);
}
public IEnumerable <Branch> GetBranchList(BranchRequest request = null)
{
request = request ?? new BranchRequest();
using (var dbContext = new HRDbContext())
{
IQueryable <Branch> branchs = dbContext.Branchs;
if (!string.IsNullOrEmpty(request.Name))
{
branchs = branchs.Where(u => u.Name.Contains(request.Name));
}
return(branchs.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize));
}
}
public GenericResponse <List <BranchContract> > FilterBranchsByProperties(BranchRequest request)
{
DbOperation dbOperation = new DbOperation();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@Id", request.DataContract.Id),
new SqlParameter("@BranchName", request.DataContract.BranchName),
new SqlParameter("@Adress", request.DataContract.Adress),
new SqlParameter("@CityId", request.DataContract.CityId),
new SqlParameter("@DateOfLaunch", request.DataContract.DateOfLaunch),
new SqlParameter("@MailAdress", request.DataContract.MailAdress),
new SqlParameter("@PhoneNumber", request.DataContract.PhoneNumber),
};
try
{
List <BranchContract> branchsList = new List <BranchContract>();
SqlDataReader reader = dbOperation.GetData("COR.sel_FilterBranchsByProperties", parameters);
while (reader.Read())
{
branchsList.Add(new BranchContract()
{
Id = (int)reader["Id"],
CityId = (int)reader["CityId"],
Adress = (string)reader["Adress"],
MailAdress = (string)reader["MailAdress"],
BranchName = (string)reader["BranchName"],
DateOfLaunch = (DateTime)reader["DateOfLaunch"],
PhoneNumber = (string)reader["PhoneNumber"],
City = reader["CityName"].ToString()
});
}
return(new GenericResponse <List <BranchContract> >()
{
Value = branchsList, IsSuccess = true
});
}
catch
{
return(new GenericResponse <List <BranchContract> >()
{
IsSuccess = false, ErrorMessage = "FilterBranchsByProperties isteği başarısız."
});
}
}
private BranchContract AddBranch(BranchContract _contract)
{
var connect = new Connector.Banking.Connect <GenericResponse <BranchContract> >();
var request = new BranchRequest();
request.MethodName = "AddNewBranch";
request.DataContract = _contract;
var response = connect.Execute(request);
if (!response.IsSuccess)
{
MessageBox.Show($"{response.ErrorMessage}", "Hata", MessageBoxButton.OK, MessageBoxImage.Error);
return(null);
}
return(response.Value);
}
//Branch
public BranchResponse ExecuteBranch(BranchRequest request)
{
var response = new BranchResponse();
Type type = request.GetType();
if (type.FullName == "BOA.Types.Banking.BranchRequest")
{
var pr = new BOA.Process.Banking.Branch();
if (request.MethodName == "GetBranches")
{
response = pr.GetBranches((BranchRequest)request);
}
}
return(response);
}
public GenericResponse <List <BranchContract> > GetAllBranches(BranchRequest request)
{
DbOperation dbOperation = new DbOperation();
List <BranchContract> branchContracts = new List <BranchContract>();
try
{
SqlDataReader reader = dbOperation.GetData("COR.sel_GetAllBranches");
while (reader.Read())
{
branchContracts.Add(new BranchContract()
{
Id = (int)reader["Id"],
CityId = (int)reader["CityId"],
Adress = (string)reader["Adress"],
MailAdress = (string)reader["MailAdress"],
BranchName = (string)reader["BranchName"],
DateOfLaunch = (DateTime)reader["DateOfLaunch"],
PhoneNumber = (string)reader["PhoneNumber"],
City = reader["CityName"].ToString()
});
}
}
catch (Exception)
{
return(new GenericResponse <List <BranchContract> >()
{
ErrorMessage = "GetAllBranches metodu başarısız.", IsSuccess = false
});
}
if (branchContracts.Count > 0)
{
return(new GenericResponse <List <BranchContract> >()
{
Value = branchContracts, IsSuccess = true
});
}
else
{
return(new GenericResponse <List <BranchContract> >()
{
IsSuccess = false, ErrorMessage = "Hiç şube getirilemedi."
});
}
}
private List <BranchContract> FilterEngine(BranchContract _contract)
{
var connect = new Connector.Banking.Connect <GenericResponse <List <BranchContract> > >();
var request = new BranchRequest();
request.MethodName = "FilterBranchsByProperties";
request.DataContract = _contract;
var response = connect.Execute(request);
if (!response.IsSuccess)
{
MessageBox.Show($"{response.ErrorMessage}", "Hata", MessageBoxButton.OK, MessageBoxImage.Error);
return(null);
}
return(response.Value);
}
public BranchResponse GetBranches(BranchRequest request)
{
Business.Banking.Branch branchBusiness = new Business.Banking.Branch();
List <BranchContract> branchContracts = branchBusiness.GetBranches();
if (branchContracts != null)
{
return(new BranchResponse()
{
branchContracts = branchContracts,
IsSuccess = true
});
}
return(new BranchResponse()
{
IsSuccess = false
});
}
public SuccessResponse Update(BranchRequest request)
{
try
{
var currentBranch = _branchRepository.FindBy(request.Id);
currentBranch.ThrowExceptionIfRecordIsNull();
var branchToCopy = TypeAdapter.Adapt <Branch>(request);
TypeAdapter.Adapt(branchToCopy, currentBranch);
_branchValidator.ValidateAndThrowException(currentBranch, "Base,Update");
_branchRepository.Update(currentBranch);
return(new SuccessResponse {
IsSuccess = true
});
}
catch (DataAccessException)
{
throw new ApplicationException();
}
}
public async Task create(GetInput input)
{
BranchRequest output = Mapper.Map <GetInput, BranchRequest>(input);
await _branchManager.create(output);
}
public JsonResult Datatable(BranchRequest request)
{
#region 自定义动作
if (!string.IsNullOrEmpty(request.customActionType))
{
string[] id_Array = Request.Params.GetValues("id[]");
List <int> ids = new List <int>();
foreach (string i in id_Array)
{
ids.Add(int.Parse(i));
}
switch (request.customActionType)
{
case "group_action":
switch (request.customActionName)
{
case "delete":
this.OAService.DeleteBranch(ids);
break;
}
break;
case "delete":
this.OAService.DeleteBranch(ids);
break;
}
}
#endregion
var allBranch = this.OAService.GetBranchList(null);
IEnumerable <Branch> filterBranch = allBranch;
#region 搜索
if (!string.IsNullOrEmpty(request.search))
{
var isNameSearchable = Convert.ToBoolean(Request["columns[1][searchable]"]);
}
else if (request.action == "filter")
{
var NameFilter = Convert.ToString(Request["name"]).Trim();
var DescFilter = Convert.ToString(Request["desc"]).Trim();
var isNameSearchable = Convert.ToBoolean(Request["columns[1][searchable]"].ToString());
if (isNameSearchable)
{
filterBranch = filterBranch.Where(c => c.Name.ToLower().Contains(NameFilter));
}
var isDescSearchable = Convert.ToBoolean(Request["columns[2][searchable]"].ToString());
if (isDescSearchable)
{
filterBranch = filterBranch.Where(c => c.Desc.ToLower().Contains(DescFilter));
}
}
else if (request.action == "filter_cancel")
{
filterBranch = allBranch;
}
else
{
filterBranch = allBranch;
}
#endregion
#region 排序
var isNameSortable = Convert.ToBoolean(Request["columns[1][orderable]"]);
var isDescSortable = Convert.ToBoolean(Request["columns[2][orderable]"]);
var isActiveSortable = Convert.ToBoolean(Request["columns[3][orderable]"]);
var sortColumnIndex = Convert.ToInt32(Request["order[0][column]"]);
Func <Branch, string> orderingFunction = (c =>
sortColumnIndex == 1 && isNameSortable ? c.Name :
sortColumnIndex == 2 && isDescSortable ? c.Desc :
"");
var sortDirection = Request["order[0][dir]"]; // asc or desc
if (sortDirection == "asc")
{
filterBranch = filterBranch.OrderBy(orderingFunction);
}
if (sortDirection == "desc")
{
filterBranch = filterBranch.OrderByDescending(orderingFunction);
}
#endregion
var displayedBranch = filterBranch.Skip(request.start).Take(request.length);
var result = from c in displayedBranch
select new[] {
Convert.ToString(c.ID)
, c.Name
, c.Desc
, Convert.ToString(c.ID)
};
return(Json(new
{
draw = request.draw, //param.sEcho,
recordsTotal = allBranch.Count(), //alltransactions.Count(),
recordsFiltered = filterBranch.Count(),
data = result
},
JsonRequestBehavior.AllowGet));
}
public async Task create(List <GetInput2> input, string id)
{
GetInput datainsert = new GetInput();
//input.cOrderID= _branchManager.getreferenceNO("B");
//refer = input.cOrderID;
for (var i = 0; i < input.Count; i++)
{
var date3 = DateTime.Now;
datainsert.cOrderID = input[i].referno;
datainsert.cTrxCode = "B";
datainsert.cType = input[i].dropcode;
datainsert.cTypeCd = input[i].subcn;
datainsert.cPrtCode = "";
datainsert.xQtty = input[i].quantity;
datainsert.xPrtQtty = null;
datainsert.xApprQtty = null;
datainsert.xCancelCnt = null;
datainsert.dUnitPrice = null;
datainsert.cTypeDesc = null;
datainsert.cImpReq = null;
datainsert.cSenderInd = "i";
datainsert.cActno = input[i].caccountno;
datainsert.cAppvDept = null;
datainsert.cChargeTo = null;
datainsert.cCNFor = null;
datainsert.cDesc = null;
datainsert.cReceiverInd = null;
datainsert.cRecAcc = null;
datainsert.cRequestRemark = input[i].remark;
datainsert.cstatus = "N";
datainsert.cPrintReq = null;
datainsert.cBrno = input[i].branch;
datainsert.cBrActno = null;
datainsert.cCreatedBrno = input[i].branch;
datainsert.cCreatedBy = id;
datainsert.dCreated = date3;
datainsert.cCBP = null;
datainsert.cCBPRvr = null;
datainsert.cCBPDept = null;
datainsert.cCBPSender = null;
datainsert.cUpdatedBy = null;
datainsert.dUpdateBy = null;
datainsert.cApprovedBy = null;
datainsert.dApprovedBy = null;
datainsert.cPrintedBy = null;
datainsert.dtPrinted = null;
datainsert.cAcknwBy = null;
datainsert.cAcknwBrno = null;
datainsert.dAcknw = null;
datainsert.cStartNo = null;
datainsert.cEndNO = null;
datainsert.cSubActno = null;
datainsert.cRejectRemark = null;
datainsert.cActionRemark = null;
datainsert.cCNTypeCode = input[i].cntype;
datainsert.cSenderAcc = null;
datainsert.PrintTypeGrp = input[i].cngroup;
datainsert.cEmailTo = null;
datainsert.cRequestDept = input[i].cRequestDept;
BranchRequest output = Mapper.Map <GetInput, BranchRequest>(datainsert);
await _branchManager.create(output);
}
}
public async Task createforcustomer(List <GetInput2> input, string id)
{
GetInput datainsert = new GetInput();
for (var cus = 0; cus < input.Count; cus++)
{
var date3 = DateTime.Now;
datainsert.cOrderID = input[cus].referno;
datainsert.cTrxCode = "C";
datainsert.cType = input[cus].dropcode; // ctype
datainsert.cTypeCd = input[cus].subcn; //subctype
datainsert.cPrtCode = ""; //printcode
datainsert.xQtty = input[cus].quantity; //quantity
datainsert.xPrtQtty = null;
datainsert.xApprQtty = null;
datainsert.xCancelCnt = null;
datainsert.dUnitPrice = null;
datainsert.cTypeDesc = null;
datainsert.cImpReq = null;
datainsert.cSenderInd = null;
datainsert.cActno = input[cus].caccountno;// accno.
datainsert.cAppvDept = null;
datainsert.cChargeTo = null;
datainsert.cCNFor = null;
datainsert.cDesc = null;
datainsert.cReceiverInd = null;
datainsert.cRecAcc = null; //receiveracc
datainsert.cRequestRemark = input[cus].remark; //remark
datainsert.cstatus = "N";
datainsert.cPrintReq = null;
datainsert.cBrno = input[cus].branch; //branch
datainsert.cBrActno = null;
datainsert.cCreatedBrno = input[cus].branch;
datainsert.cCreatedBy = id;
datainsert.dCreated = date3;
datainsert.cCBP = null;
datainsert.cCBPRvr = null;
datainsert.cCBPDept = null;
datainsert.cCBPSender = null;
datainsert.cUpdatedBy = null;
datainsert.dUpdateBy = null;
datainsert.cApprovedBy = null;
datainsert.dApprovedBy = null;
datainsert.cPrintedBy = null;
datainsert.dtPrinted = null;
datainsert.cAcknwBy = null;
datainsert.cAcknwBrno = null;
datainsert.dAcknw = null;
datainsert.cStartNo = null;
datainsert.cEndNO = null;
datainsert.cSubActno = null;
datainsert.cRejectRemark = null;
datainsert.cActionRemark = null;
datainsert.cCNTypeCode = input[cus].cntype; //cntype
datainsert.cSenderAcc = null; //sender acc
datainsert.PrintTypeGrp = input[cus].cngroup; //cngroup
datainsert.cEmailTo = null; ///sender email
BranchRequest out1 = Mapper.Map <GetInput, BranchRequest>(datainsert);
await _branchManager.create(out1);
}
}
/// <summary>
/// Update branch details
/// </summary>
/// <param name="branchRequest">All required details</param>
/// <param name="branchID">branch guid</param>
/// <returns></returns>
public IActionResult Update(BranchRequest branchRequest, string branchID)
{
return(Ok());
}
public IActionResult Insert([FromBody] BranchRequest branchRequest)
{
return(Ok());
}
public SuccessResponse Put(BranchRequest request)
{
return(_branchService.Update(request));
}
//
// GET: /OA/Branch/
public ActionResult Index(BranchRequest request)
{
var result = this.OAService.GetBranchList(request);
return(View(result));
}
public CreateResponse Post(BranchRequest request)
{
return(_branchService.Create(request));
}
