public ActionResult GetBankBranchView()
{
BankBranchModel model = new BankBranchModel();
var BranchId = Request.QueryString["branchid"];
try
{
Branchclient = new BankBranchServiceClient();
BankBranchDto BBDto = Branchclient.GetById(BranchId != null ? Convert.ToInt32(BranchId) : 0);
model.BranchId = BBDto.BranchId;
model.BaseBranchId = BBDto.BaseBranchId;
model.BranchAddress = BBDto.BranchAddress;
model.BranchContactNos = BBDto.BranchContactNos;
model.BranchOfBank = BBDto.BranchOfBank;
model.CAId = BBDto.CAId;
model.Email1 = BBDto.Email1;
model.Email2 = BBDto.Email2;
model.FullDayBreakFromString = BBDto.FullDayBreakFrom != null?DateTime.ParseExact(BBDto.FullDayBreakFrom.Value.ToString(@"hh\:mm"), "HH:mm", null).ToString("hh:mm tt", CultureInfo.GetCultureInfo("en-US")) : "00:00 AM"; //Convert.ToInt32(BBDto.FullDayBreakFrom.Value.ToString(@"hh")) < 12 ? BBDto.FullDayBreakFrom.Value.ToString(@"hh\:mm") + Space + AM : BBDto.FullDayBreakFrom.Value.ToString(@"hh\:mm") + Space + PM : "00:00 AM";
model.FullDayBreakToString = BBDto.FullDayBreakTo != null?DateTime.ParseExact(BBDto.FullDayBreakTo.Value.ToString(@"hh\:mm"), "HH:mm", null).ToString("hh:mm tt", CultureInfo.GetCultureInfo("en-US")) : "00:00 AM"; // Convert.ToInt32(BBDto.FullDayBreakTo.Value.ToString(@"hh")) < 12 ? BBDto.FullDayBreakTo.Value.ToString(@"hh\:mm") + Space + AM : BBDto.FullDayBreakTo.Value.ToString(@"hh\:mm") + Space + PM : "00:00 AM";
model.FullDayTimeFromString = BBDto.FullDayTimeFrom != null?DateTime.ParseExact(BBDto.FullDayTimeFrom.Value.ToString(@"hh\:mm"), "HH:mm", null).ToString("hh:mm tt", CultureInfo.GetCultureInfo("en-US")) : "00:00 AM"; //Convert.ToInt32(BBDto.FullDayTimeFrom.Value.ToString(@"hh")) < 12 ? BBDto.FullDayTimeFrom.Value.ToString(@"hh\:mm") + Space + AM : BBDto.FullDayTimeFrom.Value.ToString(@"hh\:mm") + Space + PM : "00:00 AM";
model.FullDayTimeToString = BBDto.FullDayTimeTo != null?DateTime.ParseExact(BBDto.FullDayTimeTo.Value.ToString(@"hh\:mm"), "HH:mm", null).ToString("hh:mm tt", CultureInfo.GetCultureInfo("en-US")) : "00:00 AM"; //Convert.ToInt32(BBDto.FullDayTimeTo.Value.ToString(@"hh")) < 12 ? BBDto.FullDayTimeTo.Value.ToString(@"hh\:mm") + Space + AM : BBDto.FullDayTimeTo.Value.ToString(@"hh\:mm") + Space + PM : "00:00 AM";
model.HalfDayBreakFromString = BBDto.HalfDayBreakFrom != null?DateTime.ParseExact(BBDto.HalfDayBreakFrom.Value.ToString(@"hh\:mm"), "HH:mm", null).ToString("hh:mm tt", CultureInfo.GetCultureInfo("en-US")) : "00:00 AM"; //Convert.ToInt32(BBDto.HalfDayBreakFrom.Value.ToString(@"hh")) < 12 ? BBDto.HalfDayBreakFrom.Value.ToString(@"hh\:mm") + Space + AM : BBDto.HalfDayBreakFrom.Value.ToString(@"hh\:mm") + Space + PM : "00:00 AM";
model.HalfDayBreakToString = BBDto.HalfDayBreakTo != null?DateTime.ParseExact(BBDto.HalfDayBreakTo.Value.ToString(@"hh\:mm"), "HH:mm", null).ToString("hh:mm tt", CultureInfo.GetCultureInfo("en-US")) : "00:00 AM"; //Convert.ToInt32(BBDto.HalfDayBreakTo.Value.ToString(@"hh")) < 12 ? BBDto.HalfDayBreakTo.Value.ToString(@"hh\:mm") + Space + AM : BBDto.HalfDayBreakTo.Value.ToString(@"hh\:mm") + Space + PM : "00:00 AM";
model.HalfDayTimeFromString = BBDto.HalfDayTimeFrom != null?DateTime.ParseExact(BBDto.HalfDayTimeFrom.Value.ToString(@"hh\:mm"), "HH:mm", null).ToString("hh:mm tt", CultureInfo.GetCultureInfo("en-US")) : "00:00 AM"; //Convert.ToInt32(BBDto.HalfDayTimeFrom.Value.ToString(@"hh")) < 12 ? BBDto.HalfDayTimeFrom.Value.ToString(@"hh\:mm") + Space + AM : BBDto.HalfDayTimeFrom.Value.ToString(@"hh\:mm") + Space + PM : "00:00 AM";
model.HalfDayTimeToString = BBDto.HalfDayTimeTo != null?DateTime.ParseExact(BBDto.HalfDayTimeTo.Value.ToString(@"hh\:mm"), "HH:mm", null).ToString("hh:mm tt", CultureInfo.GetCultureInfo("en-US")) : "00:00 AM"; //Convert.ToInt32(BBDto.HalfDayTimeTo.Value.ToString(@"hh")) < 12 ? BBDto.HalfDayTimeTo.Value.ToString(@"hh\:mm") + Space + AM : BBDto.HalfDayTimeTo.Value.ToString(@"hh\:mm") + Space + PM : "00:00 AM";
model.IFSCCode = BBDto.IFSCCode;
model.MICRCode = BBDto.MICRCode;
model.Name = BBDto.Name;
model.SWIFTCode = BBDto.SWIFTCode;
model.WeeklyHalfDay = BBDto.WeeklyHalfDay;
model.WeeklyOffDay = BBDto.WeeklyOffDay;
}
catch (Exception ex)
{
return(View("ErrorPage"));
}
finally
{
if (Branchclient != null)
{
Branchclient.Close();
}
}
return(View("AckAndClientCommonViews\\BankBranchView", model));
}
public static IList <BankBranchDto> GetAllBankandBranche()
{
BankBranchServiceReference.BankBranchServiceClient bankBranchServiceClient = new BankBranchServiceClient();
BankBranchDtoList = bankBranchServiceClient.FindAll().Entities.ToList();
BankBranchDtoList.Insert(0, new BankBranchDto
{
BranchId = 0,
Name = "",
BranchOfBank = new BankDto
{
BankName = "[Select]"
}
});
return(BankBranchDtoList);
}
public List <BankBranchDto> GetBankBranchList(int BankId)
{
UserDto currentUserDto = (UserDto)Session[Constants.SKCURRENTUSER];
Query subquery1 = new Query();
if (Helper.IsCAIdNotNull(currentUserDto))
{
Criterion criteriaCAId = new Criterion(Constants.CAID, Helper.GetCAIdOfUser(currentUserDto), CriteriaOperator.Equal);
subquery1.Add(criteriaCAId);
Criterion criteriaCAIdNULL = new Criterion(Constants.CAID, null, CriteriaOperator.IsNullOrZero);
subquery1.Add(criteriaCAIdNULL);
subquery1.QueryOperator = QueryOperator.Or;
}
else
{
Criterion criteriaCAIdNULL = new Criterion(Constants.CAID, null, CriteriaOperator.IsNullOrZero);
subquery1.Add(criteriaCAIdNULL);
}
Query query = new Query();
if (Helper.IsCAIdNotNull(currentUserDto))
{
query.CAId = Convert.ToInt32(Helper.GetCAIdOfUser(currentUserDto));
}
Criterion criteriaBankId = new Criterion("banks.BankId", BankId, CriteriaOperator.Equal);
query.Add(criteriaBankId);
query.AddAlias(new Alias("banks", "BranchOfBank"));
query.QueryOperator = QueryOperator.And;
query.AddSubQuery(subquery1);
Branchclient = new BankBranchServiceClient();
var BankBranches = Branchclient.FindByQuery(query);
Branchclient.Close();
return(BankBranches.Entities.ToList());
}
////function to check wheather chequeDate is greater than 6 months from current date
//public bool CheckChequeDate(string chequeDate)
//{
// DateTime chequeDDTransactionDate;
// double totalDays;
// bool isChequeDateGreaterThanSixMonths=false;
// if(!string.IsNullOrEmpty(chequeDate))
// {
// DateTimeFormatInfo dateTimeFormatInfo = new DateTimeFormatInfo();
// dateTimeFormatInfo.ShortDatePattern = "dd-MM-yyyy";
// dateTimeFormatInfo.DateSeparator = "-";
// chequeDDTransactionDate = Convert.ToDateTime(chequeDate, dateTimeFormatInfo);
// totalDays = chequeDDTransactionDate.Subtract(DateTime.Now).TotalDays;
// if(totalDays >90)
// {
// isChequeDateGreaterThanSixMonths = true;
// }
// }
// return isChequeDateGreaterThanSixMonths;
//}
#endregion
#region SearchBankandBranch
public ActionResult SearchBankandBranch()
{
bool flag = false;
string bankName = Request.Params["bankName"];
string bankBranch = Request.Params["bankBranch"];
string place = Request.Params["place"];
string IFSCCode = Request.Params["IFSCCode"];
string MICRCode = Request.Params["MICRCode"];
string SWIFTCode = Request.Params["SWIFTCode"];
BankBranchServiceReference.BankBranchServiceClient bankBranchServiceClient = new BankBranchServiceClient();
IList <BankBranchDto> bankBranchDtoList = null;
Query query = new Query();
if (!string.IsNullOrEmpty(bankName))
{
flag = true;
Criterion criterionBankName = new Criterion("BranchBank.BankName", bankName, CriteriaOperator.Equal);
query.AddAlias(new Alias("BranchBank", "BranchOfBank"));
query.Add(criterionBankName);
}
if (!string.IsNullOrEmpty(bankBranch))
{
flag = true;
Criterion criterionBranchName = new Criterion("Name", bankBranch, CriteriaOperator.Equal);
query.Add(criterionBranchName);
}
if (!string.IsNullOrEmpty(place))
{
flag = true;
Criterion criterionplace = new Criterion("cv.Name", place, CriteriaOperator.Equal);
query.AddAlias(new Alias("ba", "BranchAddress"));
query.AddAlias(new Alias("cv", "ba.CityVillage"));
query.Add(criterionplace);
}
if (!string.IsNullOrEmpty(IFSCCode))
{
flag = true;
Criterion criterionIFSCCode = new Criterion("IFSCCode", IFSCCode, CriteriaOperator.Equal);
query.Add(criterionIFSCCode);
}
if (!string.IsNullOrEmpty(MICRCode))
{
flag = true;
Criterion criterionMICRCode = new Criterion("MICRCode", MICRCode, CriteriaOperator.Equal);
query.Add(criterionMICRCode);
}
if (!string.IsNullOrEmpty(SWIFTCode))
{
flag = true;
Criterion criterionSWIFTCode = new Criterion("SWIFTCode", SWIFTCode, CriteriaOperator.Equal);
query.Add(criterionSWIFTCode);
}
if (flag)
{
query.QueryOperator = QueryOperator.And;
bankBranchDtoList = bankBranchServiceClient.FindByQuery(query).Entities;
bankBranchServiceClient.Close();
ViewData["SearchBank"] = bankBranchDtoList;
}
else
{
ViewData["SearchBank"] = null;
}
return(PartialView("CBPPopupSearchBankBranchGrid", ViewData["SearchBank"]));
}
