public bool ObjectExists(AgencyDTO agency)
{
var objectExists = false;
var iDbContext = DbContextUtil.GetDbContextInstance();
try
{
var catRepository = new Repository <AgencyDTO>(iDbContext);
var catExists = catRepository
.Query()
.Filter(bp => bp.AgencyName == agency.AgencyName && bp.Id != agency.Id)
.Get()
.FirstOrDefault();
if (catExists != null)
{
objectExists = true;
}
}
finally
{
iDbContext.Dispose();
}
return(objectExists);
}
public string Guide_AgencyGetAllByRole(string d, string ri, string w)
{
DateTime?date = null;
try
{
date = DateTime.ParseExact(d, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
catch { }
var routeId = -1;
try
{
routeId = Int32.Parse(ri);
}
catch { }
var way = w;
var route = TransferRequestByDateBLL.RouteGetById(routeId);
var role = TransferRequestByDateBLL.RoleGetByName("Guides");
var listGuide = TransferRequestByDateBLL.AgencyGetAllByRole(role).Future().ToList();
var listGuideInDay = TransferRequestByDateBLL.Guide_AgencyGetAllGuideInDay(role, date, route).Future().ToList();
var listGuideDTO = new List <AgencyDTO>();
listGuide.ForEach(guide =>
{
var guideInDay = listGuideInDay.Where(x => x.Id == guide.Id).FirstOrDefault();
Expense guideExpenseInDay = null;
if (guideInDay != null)
{
guideExpenseInDay = TransferRequestByDateBLL.ExpenseGetAllByCriterion(guide, date, route)
.Future().SingleOrDefault();
}
var guideDTO = new AgencyDTO()
{
Id = guide.Id,
Name = guideExpenseInDay != null ? guideExpenseInDay.Guide.Name + " - " + guideExpenseInDay.Cruise.Code : guide.Name,
Group = guideInDay != null ? "Guide in day" : null,
};
listGuideDTO.Add(guideDTO);
});
if (way == "Back")
{
var listGuideDayBefore = TransferRequestByDateBLL.Guide_AgencyGetAllGuideInDay(role, date.Value.AddDays(-1), route).Future().ToList();
listGuideDayBefore.ForEach(guideDayBefore =>
{
var guideDTO = new AgencyDTO()
{
Id = guideDayBefore.Id,
Name = guideDayBefore.Name,
Group = guideDayBefore != null ? "Guide day before" : null,
};
listGuideDTO.Add(guideDTO);
});
}
Dispose();
return(JsonConvert.SerializeObject(listGuideDTO));
}
public bool Edit(AgencyDTO AD)
{
try
{
A_DAL.Edit(AD);
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public ServerAgencyViewModel()
{
CleanUp();
var iDbContext = new ServerDbContextFactory().Create();
_unitOfWork = new UnitOfWorkServer(iDbContext);
SelectedAgency = new AgencyDTO();
Agencys = new ObservableCollection <AgencyDTO>();
GetLiveAgencys();
EditCommandVisibility = false;
}
private async void setDate()
{
int _month = int.Parse(Request["month"]);
int agency_fk = int.Parse(Request["agency_fk"]);
string _total = Request["total"];
Year = Request["year"];
Agency = Request["Agency"];
Address = Request["Address"];
Date = DateTime.Today.ToString("yyyy-MM-dd");
Month = DateTimeFormatInfo.CurrentInfo.GetMonthName(_month);
decimal sum_d = decimal.Parse(_total);
Sum = String.Format("{0:C}", sum_d);
decimal base_d = (sum_d / (decimal)1.1);
Base = String.Format("{0:C}", base_d);
VAT = String.Format("{0:C}", (sum_d - base_d));
using (var client = new HttpClient())
{
// New code:
var api_url = ConfigurationManager.AppSettings["api_url"];
client.BaseAddress = new Uri(api_url);
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage response = await client.GetAsync("/api/agencies/" + agency_fk);
if (response.IsSuccessStatusCode)
{
AgencyDTO agency = await response.Content.ReadAsAsync <AgencyDTO>();// .ReadAsAsync ();// .Content.ReadAsAsync > Product > ();
//}
Agency = agency.name;
Address = agency.address;
}
DueDate = DateTime.Today.AddMonths(1).ToString("yyyy-MM-dd");
//= Math.Round(base_d, 2).ToString("");
}
}
public void GetAgency()
{
var role = Module.RoleGetByName("Cruise Suppliers");
var agencys = Module.AgencyGetAllByRole(role);
var list = new List <AgencyDTO>();
foreach (Agency r in agencys)
{
var agencyDto = new AgencyDTO();
agencyDto.Id = r.Id;
agencyDto.Name = r.Name;
list.Add(agencyDto);
}
HttpContext.Current.Response.ContentType = "application/json";
HttpContext.Current.Response.Charset = "utf-8";
HttpContext.Current.Response.Write(JsonConvert.SerializeObject(list));
}
public string Supplier_AgencyGetAllByRole()
{
var role = TransferRequestByDateBLL.RoleGetByName("Suppliers");
var listSupplier = TransferRequestByDateBLL.AgencyGetAllByRole(role).Future().ToList();
var listSupplierDTO = new List <AgencyDTO>();
listSupplier.ForEach(supplier =>
{
var supplierDTO = new AgencyDTO()
{
Id = supplier.Id,
Name = supplier.Name,
};
listSupplierDTO.Add(supplierDTO);
});
Dispose();
return(JsonConvert.SerializeObject(listSupplierDTO));
}
public async Task <AgencyDTO> GetAgencyByAgencyNameAsync(string name)
{
using (var conn = new SqlConnection(_connectionSettings.DefaultConnection))
{
var result = new AgencyDTO();
const string storeproc = @"[dbo].[uspAgenciesGetByName_New]";
await conn.OpenAsync();
var dynParm = new
{
name = name
};
var rawResult = await conn.QueryAsync <AgencyDTO>(storeproc, dynParm, null, null, CommandType.StoredProcedure);
result = rawResult.FirstOrDefault();
return(result);
}
}
public string AgencyGetAllBy(string ui, string f, string t)
{
int userId = -1;
try
{
userId = Int32.Parse(ui);
}
catch { }
DateTime?from = null;
try
{
from = DateTime.ParseExact(f, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
catch { }
DateTime?to = null;
try
{
to = DateTime.ParseExact(t, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
catch { }
var listAgency = ViewActivitiesBLL.AgencyGetAllBy(userId, from, to);
var listAgencyDTO = new List <AgencyDTO>();
foreach (var agency in listAgency)
{
var agencyDTO = new AgencyDTO()
{
Id = agency.Id.ToString(),
Name = agency.Name,
Phone = agency.Phone,
Fax = agency.Fax,
Email = agency.Email,
RoleName = agency.Role.Name,
};
listAgencyDTO.Add(agencyDTO);
}
return(JsonConvert.SerializeObject(listAgencyDTO));
}
protected void function_insert_Click(object sender, EventArgs e)
{
AgencyDTO ALO = new AgencyDTO();
ALO.NAME_AGENCY = input_NameAgency.Text;
ALO.ADDR = input_Addr.Text;
ALO.NUMPHONE = input_Numphone.Text;
ALO.ACTIVATE = Int32.Parse(rdo_Activate.SelectedValue.ToString());
if (ABL.Insert(ALO) == true)
{
MessageBox("Thêm thành công", "Agency.aspx");
uploadData();
}
else
{
MessageBox("Thêm không thành công", "Agency.aspx");
uploadData();
}
}
protected void btn_edit_Click(object sender, EventArgs e)
{
AgencyDTO ALO = new AgencyDTO();
ALO.NAME_AGENCY = input_name.Text;
ALO.ADDR = input_addr.Text;
ALO.NUMPHONE = input_numphone.Text;
ALO.ACTIVATE = Int32.Parse(rdo_Activate.SelectedValue.ToString());
ALO.ID_AGENCY = input_id.Text;
if (ABL.Edit(ALO) == true)
{
MessageBox("Sửa thành công", "Agency.aspx");
}
else
{
MessageBox("Sửa không thành công", "Agency.aspx");
}
}
public void Insert(AgencyDTO TOP)
{
ConnectDB.con.Open();
try
{
SqlCommand cmd = new SqlCommand("insert_Agency", ConnectDB.con);
cmd.Parameters.Add("@NAME_AGENCY", SqlDbType.NVarChar).Value = TOP.NAME_AGENCY;
cmd.Parameters.Add("@ADDR", SqlDbType.NVarChar).Value = TOP.ADDR;
cmd.Parameters.Add("@NUMPHONE", SqlDbType.VarChar).Value = TOP.NUMPHONE;
cmd.Parameters.Add("@ACTIVATE", SqlDbType.Int).Value = TOP.ACTIVATE;
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
ConnectDB.con.Close();
}
}
public string InsertOrUpdate(AgencyDTO agency)
{
string stat;
try
{
var validate = Validate(agency);
if (!string.IsNullOrEmpty(validate))
{
stat = validate;
}
else
{
if (ObjectExists(agency))
{
stat = GenericMessages.DatabaseErrorRecordAlreadyExists;
}
else
{
agency.Synced = false;
_localAgencyRepository.InsertUpdate(agency);
_unitOfWork.Commit();
stat = string.Empty;
}
}
}
catch (Exception exception)
{
stat = exception.Message;
}
finally
{
Dispose(_disposeWhenDone);
}
return(stat);
}
public string Validate(AgencyDTO agency)
{
if (agency == null)
{
return(GenericMessages.ObjectIsNull);
}
if (agency.Address == null)
{
return("Address " + GenericMessages.ObjectIsNull);
}
if (String.IsNullOrEmpty(agency.AgencyName))
{
return(agency.AgencyName + " " + GenericMessages.StringIsNullOrEmpty);
}
if (agency.AgencyName.Length > 255)
{
return(agency.AgencyName + " can not be more than 255 characters ");
}
return(string.Empty);
}
public bool SyncAgencies(IUnitOfWork sourceUnitOfWork, IUnitOfWork destinationUnitOfWork)
{
var sourceList = sourceUnitOfWork.Repository <AgencyDTO>().Query()
.Include(h => h.Header, h => h.Footer, h => h.Address)
.Filter(a => !a.Synced && a.DateLastModified > LastServerSyncDate)
.Get(1)
.ToList();
if (sourceList.Any())
{
_updatesFound = true;
var destAddresses =
destinationUnitOfWork.Repository <AddressDTO>().Query()
.Filter(a => a.AgencyId == Singleton.Agency.Id)
.Get(1)
.ToList();
var destHeadersFooters =
destinationUnitOfWork.Repository <AttachmentDTO>().Query()
.Filter(a => a.AgencyId == Singleton.Agency.Id)
.Get(1)
.ToList();
var destList =
destinationUnitOfWork.Repository <AgencyDTO>().Query()
.Filter(a => a.Id == Singleton.Agency.Id)
.Include(a => a.Address)
.Get(1)
.ToList();
foreach (var source in sourceList)
{
var destination =
destList.FirstOrDefault(i => i.RowGuid == source.RowGuid);
var clientId = 0;
if (destination == null)
{
destination = new AgencyDTO();
}
else
{
clientId = destination.Id;
}
try
{
Mapper.Reset();
Mapper.CreateMap <AgencyDTO, AgencyDTO>()
.ForMember("Address", option => option.Ignore())
.ForMember("Header", option => option.Ignore())
.ForMember("Footer", option => option.Ignore())
.ForMember("Synced", option => option.Ignore());
destination = Mapper.Map(source, destination);
destination.Id = clientId;
destination.CreatedByUserId = GetDestCreatedModifiedByUserId(source.CreatedByUserId,
sourceUnitOfWork, destinationUnitOfWork);
destination.ModifiedByUserId = GetDestCreatedModifiedByUserId(source.ModifiedByUserId,
sourceUnitOfWork, destinationUnitOfWork);
}
catch (Exception ex)
{
LogUtil.LogError(ErrorSeverity.Critical, "SyncAgencies Mapping",
ex.Message + Environment.NewLine + ex.InnerException, UserName, Agency);
//UpdatingText = "Problem mapping AgencyDTO";
}
try
{
#region Foreign Keys
var categoryDto =
destAddresses.FirstOrDefault(
c => source.Address != null && c.RowGuid == source.Address.RowGuid);
{
destination.Address = categoryDto;
destination.AddressId = categoryDto != null ? categoryDto.Id : (int?)null;
}
var headerDto =
destHeadersFooters.FirstOrDefault(
c => source.Header != null && c.RowGuid == source.Header.RowGuid);
{
destination.Header = headerDto;
destination.HeaderId = headerDto != null ? headerDto.Id : (int?)null;
}
var footerDto =
destHeadersFooters.FirstOrDefault(
c => source.Footer != null && c.RowGuid == source.Footer.RowGuid);
{
destination.Footer = footerDto;
destination.FooterId = footerDto != null ? footerDto.Id : (int?)null;
}
#endregion
destination.Synced = true;
destinationUnitOfWork.Repository <AgencyDTO>()
.InsertUpdate(destination);
}
catch
{
_errorsFound = true;
LogUtil.LogError(ErrorSeverity.Critical, "SyncAgencies Crud",
"Problem On SyncAgencies Crud Method", UserName, Agency);
return(false);
}
}
var changes = destinationUnitOfWork.Commit();
if (changes < 0)
{
_errorsFound = true;
LogUtil.LogError(ErrorSeverity.Critical, "SyncAgencies Commit",
"Problem Commiting SyncAgencies Method", UserName, Agency);
return(false);
}
}
return(true);
}
private void ExecuteAddNewAgencyViewCommand()
{
SelectedAgency = new AgencyDTO();
}
public bool SyncAgencies2(IUnitOfWork sourceUnitOfWork,
IUnitOfWork destinationUnitOfWork)
{
var sourceList = sourceUnitOfWork.Repository <AgencyDTO>().Query()
.Filter(a => !a.Synced && a.DateLastModified > LastServerSyncDate)
.Get(1)
.ToList();
if (sourceList.Any())
{
_updatesFound = true;
//List<AgencyDTO> destList;
//if(Singleton.Agency!=null)
// destList =
// destinationUnitOfWork.Repository<AgencyDTO>().Query()
// .Include(a => a.Address).Filter(a => a.Id == Singleton.Agency.Id)
// .Get(1)
// .ToList();
//else destList =
// destinationUnitOfWork.Repository<AgencyDTO>().Query()
// .Include(a => a.Address)
// .Get(1)
// .ToList();
foreach (var source in sourceList)
{
AgencyDTO source1 = source;
var destination =
destinationUnitOfWork.Repository <AgencyDTO>().Query()
.Filter(i => i.RowGuid == source1.RowGuid)
.Include(a => a.Address)
.Get(1).FirstOrDefault();
const int clientId = 0;
if (destination == null)
{
destination = new AgencyDTO();
}
else
{
continue;//clientId = destination.Id;
}
try
{
Mapper.Reset();
Mapper.CreateMap <AgencyDTO, AgencyDTO>()
.ForMember("Address", option => option.Ignore())
.ForMember("Header", option => option.Ignore())
.ForMember("Footer", option => option.Ignore())
.ForMember("AddressId", option => option.Ignore())
.ForMember("HeaderId", option => option.Ignore())
.ForMember("FooterId", option => option.Ignore())
.ForMember("Synced", option => option.Ignore());
destination = Mapper.Map(source, destination);
destination.Id = clientId;
destination.Address = null;
destination.AddressId = null;
destination.Header = null;
destination.HeaderId = null;
destination.Footer = null;
destination.FooterId = null;
destination.CreatedByUserId = GetDestCreatedModifiedByUserId(source.CreatedByUserId,
sourceUnitOfWork, destinationUnitOfWork);
destination.ModifiedByUserId = GetDestCreatedModifiedByUserId(source.ModifiedByUserId,
sourceUnitOfWork, destinationUnitOfWork);
}
catch (Exception ex)
{
LogUtil.LogError(ErrorSeverity.Critical, "SyncAgencies Mapping",
ex.Message + Environment.NewLine + ex.InnerException, UserName, Agency);
//UpdatingText = "Problem mapping AgencyDTO";
}
try
{
destination.Synced = true;
destinationUnitOfWork.Repository <AgencyDTO>()
.InsertUpdate(destination);
}
catch
{
_errorsFound = true;
LogUtil.LogError(ErrorSeverity.Critical, "SyncAgencies Crud",
"Problem On SyncAgencies Crud Method", UserName, Agency);
return(false);
}
}
var changes = destinationUnitOfWork.Commit();
if (changes < 0)
{
_errorsFound = true;
LogUtil.LogError(ErrorSeverity.Critical, "SyncAgencies Commit",
"Problem Commiting SyncAgencies Method", UserName, Agency);
return(false);
}
}
return(true);
}
private void DoWork(object sender, DoWorkEventArgs e)
{
ProductActivation.ProductKey = ProductKey;
var key = _dbContext.ActivationKeys
.FirstOrDefault(a => a.ProductKey == ProductActivation.ProductKey &&
a.KeyStatus == 0 && a.ProductType == 0);
//O represents Active and O represents PinnaFace
if (key != null)
{
try
{
if (string.IsNullOrEmpty(key.BIOS_SN))
{
key.BIOS_SN = ProductActivation.BiosSn;
//key.FirstActivatedDate = DateTime.Now;
// //GETUTCDATETIME StoredPr. //the time will be better if it is the server timer
//key.ExpirationDate = key.FirstActivatedDate.Value.AddDays(key.ExpiryDuration);
}
else
{
if (!key.BIOS_SN.Contains(ProductActivation.BiosSn))
{
if (key.NoOfAllowedPcs == 1)
{
MessageBox.Show(
"Can't Activate the product, " +
"Check your product key and try again, " +
"or contact pinnaface office!", "More than Allowed Pcs");
ProductKey = "";
CommandsEnability = true;
return;
}
key.BIOS_SN = key.BIOS_SN + "," + ProductActivation.BiosSn;
if (key.BIOS_SN.Split(',').Count() > key.NoOfAllowedPcs)
{
MessageBox.Show(
"Can't Activate the product, " +
"Check your product key and try again, " +
"or contact pinnaface office!", "More than Allowed Pcs");
ProductKey = "";
CommandsEnability = true;
return;
}
}
}
key.NoOfActivations = key.NoOfActivations + 1;
if (key.NoOfActivations > key.NoOfAllowedActivations)
{
MessageBox.Show(
"Can't Activate the product, " +
"Check your product key and try again, " +
"or contact pinnaface office!", "More than Allowed Activations");
ProductKey = "";
CommandsEnability = true;
return;
}
_dbContext.Add(key);
_dbContext.SaveChanges();
ProductActivation.RegisteredBiosSn = key.BIOS_SN;
ProductActivation.DateLastModified = DbCommandUtil.GetCurrentSqlDate(true);// DateTime.Now; //GETUTCDATETIME StoredPr
ProductActivation.Synced = false;
if (ProductActivation.Id == 0)
{
ProductActivation.LicensedTo = key.CustomerName;
ProductActivation.DatabaseVersionDate = Singleton.SystemVersionDate;
ProductActivation.MaximumSystemVersion = key.MaximumAllowedSystemVersion;
ProductActivation.ModifiedByUserId = 1;
ProductActivation.CreatedByUserId = 1;
ProductActivation.DateRecordCreated = DbCommandUtil.GetCurrentSqlDate(true);//DateTime.Now; //GETUTCDATETIME StoredPr
#region Set UserAccounts
ProductActivation.SuperName = key.SuperName; //.Email;
ProductActivation.SuperPass = key.SuperPass;
ProductActivation.AdminName = key.AdminName;
ProductActivation.AdminPass = key.AdminPass;
ProductActivation.User1Name = key.User1Name;
ProductActivation.User1Pass = key.User1Pass;
#endregion
#region Agency
var localAgency = new AgencyDTO
{
AgencyName = key.CustomerName ?? (key.CustomerName = ""),
AgencyNameAmharic = "-",
ManagerName = "-",
ManagerNameAmharic = "-",
Address = new AddressDTO
{
AddressType = AddressTypes.Local,
Country = CountryList.Ethiopia,
City = EnumUtil.GetEnumDesc(CityList.AddisAbeba),
Region = "14",
Telephone = key.Telephone ?? (key.Telephone = ""),
PrimaryEmail = key.Email ?? (key.Email = "")
},
Header = new AttachmentDTO(),
Footer = new AttachmentDTO(),
LicenceNumber = "-",
SaudiOperation = key.SaudiOperation,
DubaiOperation = key.DubaiOperation,
KuwaitOperation = key.KuwaitOperation,
QatarOperation = key.QatarOperation,
JordanOperation = key.JordanOperation,
LebanonOperation = key.LebanonOperation,
BahrainOperation = key.BahrainOperation,
DepositAmount = "100,000 USD",
Managertype = "ዋና ስራ አስኪያጅ"
};
#endregion
#region Foreign Agents
var foreignAgent = new AgentDTO
{
AgentName = "-",
AgentNameAmharic = "-",
Address = new AddressDTO
{
AddressType = AddressTypes.Foreign,
Country = CountryList.SaudiArabia,
City = EnumUtil.GetEnumDesc(CityList.Riyadh)
},
LicenseNumber = "-",
Header = new AttachmentDTO(),
Footer = new AttachmentDTO(),
};
#endregion
#region Setting
var setting = new SettingDTO
{
AwajNumber = "923/2008",
EmbassyApplicationType = EmbassyApplicationTypes.SponsorNameOnTop,
SyncDuration = 1,
StartSync = true,
};
#endregion
ProductActivation.FirstActivatedDate = key.FirstActivatedDate; // DateTime.Now; //GETUTCDATETIME StoredPr
ProductActivation.ExpiryDate = key.ExpiryDate; // DateTime.Now.AddDays(key.ExpiryDuration);
ProductActivation.Agency = localAgency;
setting.Agency = localAgency;
////Since we don't update Header and Footer from Server we didnt need the following 6 lines
//localAgency.Address.Agency = localAgency;
//localAgency.Header.Agency = localAgency;
//localAgency.Footer.Agency = localAgency;
//foreignAgent.Address.Agency = localAgency;
//foreignAgent.Header.Agency = localAgency;
//foreignAgent.Footer.Agency = localAgency;
_unitOfWork.Repository <AgencyDTO>().Insert(localAgency);
_unitOfWork.Repository <AgentDTO>().Insert(foreignAgent);
_unitOfWork.Repository <SettingDTO>().Insert(setting);
_unitOfWork.Repository <ProductActivationDTO>().Insert(ProductActivation);
}
else
{
//localAgency.Synced = false;
//foreignAgent.Synced = false;
//_unitOfWork.Repository<AgencyDTO>().Update(localAgency);
//_unitOfWork.Repository<AgentDTO>().Update(foreignAgent);
_unitOfWork.Repository <ProductActivationDTO>().Update(ProductActivation);
}
int changes = _unitOfWork.Commit();
if (changes > 0)
{
Singleton.ProductActivation = ProductActivation;
_login = true;
}
else
{
MessageBox.Show(
"Can't Activate the product, check your product key and try again, or contact pinnasofts!");
ProductKey = "";
CommandsEnability = true;
}
}
catch
{
MessageBox.Show("Error:" + Environment.NewLine + " There may be no Internet connection." +
Environment.NewLine + "Check your connection and try again.");
CommandsEnability = true;
}
}
else
{
MessageBox.Show(
"Can't Activate the product, check your product key and try again, or contact pinnasofts!");
ProductKey = "";
CommandsEnability = true;
}
}
