public DTO.Palestrante CreateNewPalestrante(DTO.Palestrante palestrante)
{
using (var db = new SemanaTecnologiaEntities())
{
var PalestranteRow = db.Palestrante.Create();
PalestranteRow.NAME = palestrante.NAME;
PalestranteRow.EMAIL = palestrante.EMAIL;
PalestranteRow.CV = palestrante.CV;
PalestranteRow.CITY = palestrante.CITY;
PalestranteRow.TEL = palestrante.TEL;
PalestranteRow.TITRATION = palestrante.TITRATION;
db.Palestrante.Add(PalestranteRow);
db.SaveChanges();
palestrante.PK_PALESTRANTE = PalestranteRow.PK_PALESTRANTE;
return palestrante;
}
}
public UcInfo(DTO.SanPham data)
{
InitializeComponent();
this.data = data;
isUpdate = true;
lbSelect.Text = Constant.DEFAULT_TITLE_EDIT;
if (Init())
{
tbMa.Text = data.Id.ToString();
tbTen.Text = data.Ten;
tbGia.Text = data.Gia.ToString();
cbDVT.Text = data.DonViTinh;
if (data.IsActived)
{
rbBan.Checked = true;
}
else
{
rbTamNgung.Checked = true;
}
tbGhiChu.Text = data.GhiChu;
}
else
{
this.Visible = false;
}
}
public static int Create(DTO.FIC_ShippingVolumeHeader item)
{
int result = 0;
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@SVHeaderNo_", item.SVHeaderNo_.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@SVHeaderDate", item.SVHeaderDate));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@InvoiceNo_", item.InvoiceNo_.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@InvoiceSerialNo_", item.InvoiceSerialNo_.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@InvoiceFormNo_", item.InvoiceFormNo_.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@InvoiceDate", item.InvoiceDate));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ContractNo_", item.ContractNo_.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@FromPartnerNo_", item.FromPartnerNo_.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ToPartnerNo_", item.ToPartnerNo_.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Status", item.Status));
result = conn.ExecuteNonQuery("sp_FIC_ShippingVolumeHeader_Create", lsInput);
}
catch (Exception ex)
{
result = -1;
}
finally
{
conn.Close();
}
return result;
}
public static int Create(DTO.MAD_Employee item)
{
int result = 0;
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@EmployeeNo_", item.EmployeeNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@EmployeeName", item.EmployeeName));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@EmployeeType", item.EmployeeType));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@IdentityCard", item.IdentityCard));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Cellphone", item.Cellphone));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@BeginDate", item.BeginDate));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Status", item.Status));
result = conn.ExecuteNonQuery("sp_MAD_Employee_Create", lsInput);
}
catch (Exception ex)
{
result = -1;
}
finally
{
conn.Close();
}
return result;
}
public static int Create(DTO.MAD_Transportation item)
{
int result = 0;
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@TransportationNo_", item.TransportationNo_.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@TransportationName", item.TransportationName.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@RoMooc", item.RoMooc.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Status", item.Status));
result = conn.ExecuteNonQuery("sp_MAD_Transportation_Create", lsInput);
}
catch (Exception ex)
{
result = -1;
}
finally
{
conn.Close();
}
return result;
}
public void ThemKIEUPHONG(DTO.DTOKIEUPHONG e)
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@MAKP", e.MAKP));
parameters.Add(new SqlParameter("@TENKP", e.TENKP));
conn.ExecuteProcedure("THEMVAOKIEUPHONG",parameters);
}
public void Save(DTO.Macro item)
{
using (var sqlMacro = new DataLayer.RemoteHelperDataContext())
{
if (item.Id.HasValue)
{
var items_to_delete = (from itms in sqlMacro.MacroSteps
where itms.MacroId == item.Id
select itms);
foreach (var item_to_delete in items_to_delete)
{
sqlMacro.MacroSteps.DeleteOnSubmit(item_to_delete);
}
}
if (item.Steps != null && item.Steps.Count > 0)
foreach (var item_to_insert in item.Steps)
{
var tmp = new DataLayer.MacroStep
{
CommandLine = null,
SequenceNumber = item_to_insert.SequenceNumber
};
sqlMacro.MacroSteps.InsertOnSubmit(tmp);
}
sqlMacro.SubmitChanges();
}
}
private void addToGrid(DTO.Product product)
{
int row = checkInGrid(product.Productid);
if (row == -1)
{
if (product.Quantity >= 1)
{
grdItems.Rows.Add(grdItems.RowCount + 1, product.Productname, 1, product.Priceout, 0, product.Priceout, "-", product.Productid, product.Pricein);
}
else
{
MessageBox.Show("No Product In Stock");
}
}
else
{
if (product.Quantity > int.Parse(grdItems.Rows[row].Cells[2].Value.ToString()))
{
grdItems.Rows[row].Cells[2].Value = int.Parse(grdItems.Rows[row].Cells[2].Value.ToString()) + 1;
decimal subtotal = (decimal.Parse(grdItems.Rows[row].Cells[2].Value.ToString()) * decimal.Parse(grdItems.Rows[row].Cells[3].Value.ToString()));
decimal discount = subtotal*decimal.Parse(grdItems.Rows[row].Cells[4].Value.ToString())/100;
grdItems.Rows[row].Cells[5].Value = subtotal - discount;
}
else
{
MessageBox.Show("Not enought product in stock");
}
}
calculate();
}
public void CapnhatKIEUPHONG(DTO.DTOKIEUPHONG e)
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@MAKP", e.MAKP));
parameters.Add(new SqlParameter("@TENKP", e.TENKP));
conn.ExecuteProcedure("CAPNHATKIEUPHONG",parameters);
}
public void CapnhatLOAIKH(DTO.DTOLOAIKH e)
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@MALOAIKH", e.MALOAIKH));
parameters.Add(new SqlParameter("@TENLOAIKH", e.TENLOAIKH));
conn.ExecuteProcedure("CAPNHATLOAIKH",parameters);
}
public void ThemLOAIKH(DTO.DTOLOAIKH e)
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@MALOAIKH", e.MALOAIKH));
parameters.Add(new SqlParameter("@TENLOAIKH", e.TENLOAIKH));
conn.ExecuteProcedure("THEMVAOLOAIKH",parameters);
}
// konstruktor, wywoływany spod BosTrades.Update()
internal BosTrade(DTO.MarketTradeData data)
{
Time = data.Time;
Price = data.Price;
Quantity = data.Quantity;
//OpenInt uzupełniamy w BosInstrument.Update
}
public static int Create(DTO.SAM_DriverShipment item)
{
int result = 0;
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ShipmentNo_", item.ShipmentNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@TransportationNo_", item.TransportationNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@UserNo_", item.UserNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@IsDriver", item.IsDriver));
result = conn.ExecuteNonQuery("sp_SAM_DriverShipment_Create", lsInput);
}
catch (Exception ex)
{
result = -1;
}
finally
{
conn.Close();
}
return result;
}
public void CapnhatTINHTRANG(DTO.DTOTINHTRANG e)
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@MATT", e.MATT));
parameters.Add(new SqlParameter("@TENTT", e.TENTT));
conn.ExecuteProcedure("CAPNHATTINHTRANG",parameters);
}
public object CreateDataShapedObject(DTO.Expense expense, List<string> lstOfFields)
{
if (!lstOfFields.Any())
{
return expense;
}
else
{
// create a new ExpandoObject & dynamically create the properties for this object
ExpandoObject objectToReturn = new ExpandoObject();
foreach (var field in lstOfFields)
{
// need to include public and instance, b/c specifying a binding flag overwrites the
// already-existing binding flags.
var fieldValue = expense.GetType()
.GetProperty(field, BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance)
.GetValue(expense, null);
// add the field to the ExpandoObject
((IDictionary<String, Object>)objectToReturn).Add(field, fieldValue);
}
return objectToReturn;
}
}
public static int Create(DTO.SAM_Contract item)
{
int result = 0;
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ContractNo_", item.ContractNo_.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@CreatedUser", item.CreatedUser.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@CreatedDate", item.CreatedDate));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@PartnerNo_", item.PartnerNo_.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ContractValue", item.ContractValue));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Status", item.Status));
result = conn.ExecuteNonQuery("sp_SAM_Contract_Create", lsInput);
}
catch (Exception ex)
{
result = -1;
}
finally
{
conn.Close();
}
return result;
}
public DTO.Participante CreateNewParticipante(DTO.Participante participante)
{
using (var db = new SemanaTecnologiaEntities())
{
var ParticipanteROW = db.Participante.Create();
ParticipanteROW.PK_PARTICIPANTE = participante.PK_PARTICIPANTE;
ParticipanteROW.COURSE = participante.COURSE;
ParticipanteROW.EMAIL = participante.EMAIL;
ParticipanteROW.LOGIN = participante.LOGIN;
ParticipanteROW.NAME = participante.NAME;
ParticipanteROW.PASSWORD = participante.PASSWORD;
ParticipanteROW.PERIOD = participante.PERIOD;
ParticipanteROW.PROFILE = participante.PROFILE;
ParticipanteROW.TEL = participante.TEL;
db.Participante.Add(ParticipanteROW);
db.SaveChanges();
return participante;
}
}
public UcInfo(DTO.SanPham data)
{
InitializeComponent();
this.data = data;
isUpdate = true;
lbSelect.Text = Constant.DEFAULT_TITLE_EDIT;
if (Init())
{
tbMa.Text = data.MaSanPham;
tbTen.Text = data.Ten;
if (data.IsActive)
{
rbBan.Checked = true;
}
else
{
rbTamNgung.Checked = true;
}
tbMoTa.Text = data.MoTa;
cbGroup.Text = data.SanPhamGroup.Ten;
}
else
{
this.Visible = false;
}
}
public static int Create(DTO.SAM_SalesPrice item)
{
int result = 0;
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ID", item.ID));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ContractNo_", item.ContractNo_.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@RouteNo_", item.RouteNo_.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ItemNo_", item.ItemNo_.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@UnitOfMeasure", item.UnitOfMeasure.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@FromDate", item.FromDate));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ToDate", item.ToDate));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@UnitPrice", item.UnitPrice));
result = conn.ExecuteNonQuery("sp_SAM_SalesPrice_Create", lsInput);
}
catch (Exception ex)
{
result = -1;
}
finally
{
conn.Close();
}
return result;
}
public UcDetail(DTO.SanPham data)
{
InitializeComponent();
this.data = data;
if (Init())
{
tbMa.Text = data.MaSanPham;
cbGroup.Text = data.SanPhamGroup.Ten;
tbTen.Text = data.Ten;
if (data.IsActive)
{
rbBan.Checked = true;
}
else
{
rbTamNgung.Checked = true;
}
tbMoTa.Text = data.MoTa;
}
else
{
this.Visible = false;
}
}
public void ThemCHITIETPDK(DTO.DTOCHITIETPDK e)
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@MAPDK", e.MAPDK));
parameters.Add(new SqlParameter("@MAPHONG", e.MAPHONG));
conn.ExecuteProcedure("THEMVAOCHITIETPDK",parameters);
}
public void ThemtblMODULE(DTO.DTOtblMODULE e)
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@MODULEID", e.MODULEID));
parameters.Add(new SqlParameter("@MODULENAME", e.MODULENAME));
conn.ExecuteProcedure("THEMVAOtblMODULE",parameters);
}
public void ThemTINHTRANG(DTO.DTOTINHTRANG e)
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@MATT", e.MATT));
parameters.Add(new SqlParameter("@TENTT", e.TENTT));
conn.ExecuteProcedure("THEMVAOTINHTRANG",parameters);
}
public void CapnhattblMODULE(DTO.DTOtblMODULE e)
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@MODULEID", e.MODULEID));
parameters.Add(new SqlParameter("@MODULENAME", e.MODULENAME));
conn.ExecuteProcedure("CAPNHATtblMODULE",parameters);
}
public ActionResult Result(DTO.Result result, string format)
{
if (format != "json")
return null;
if (ModelState.IsValid)
{
var res = _db.Results.Include(r => r.Solution.Language).Single(r => r.Id == result.Id);
res.VerdictId = result.VerdictId;
try
{
_db.Entry(res).State = EntityState.Modified;
_db.SaveChanges();
return Json("ok");
}
catch(Exception ex)
{
}
}
return Json(new ErrorMessage
{
Error = new ErrorMessage.ConctreteError
{
Type = "Not valid",
Message = "\"Result\" not valid."
}
});
}
public TachBan(string _maban, DTO.HoaDon _hd)
{
InitializeComponent();
cbxKhuVuc.DataSource = Global.listKhuVuc;
parseDataMonAn(maBUS.getMonAnBanSuDung(_maban));
currentHD = _hd;
}
void client_LoginCompleted(object sender, DTO.LoginCompletedEventArgs e)
{
EnableAllButtons(true);
_pinPressed = "";
var mainView = new MainView(e.Result);
Content = mainView;
}
public TicketDetail(DTO.Ticket t)
{
this.Id = t.Id;
this.Summary = t.Summary;
this.Priority = t.Priority;
this.CreatedOn = t.CreatedOn;
this.UpdatedAt = t.UpdatedAt;
this.MilestoneId = t.MilestoneId;
this.StatusName = t.StatusName;
this.AssignedTo = t.AssignedTo;
this.CompletedDate = t.CompletedDate;
this.ComponentId = t.ComponentId;
this.CustomFields = t.CustomFields;
this.Description = t.Description;
this.Estimate = t.Estimate;
this.Followers = t.Followers;
this.Importance = t.Importance;
this.IsOpen = t.IsOpen;
this.IsStory = t.IsStory;
this.Number = t.Number;
this.StoryImportance = t.StoryImportance;
Component = t.Component;
Milestone = t.Milestone;
Assignee = t.Assignee;
Reporter = t.Reporter;
}
// konstruktor, wywoływany spod BosPapers.Update()
internal BosPaper(BosAccount account, DTO.Paper data)
{
Account = account;
Instrument = BosInstrument.Create(data.Instrument);
Quantity110 = data.Account110;
Quantity120 = data.Account120;
}
public SMA(DTO.DuLieuMaCK DLDK)
{
InitializeComponent();
ms = new BUS.Multi_Stock();
ms.ConvertFromDuLieuMaCk(DLDK);
dldk = DLDK.LayDuLieu();
}
/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
var signature = Utility.GetMD5(Utility.GetCustomConfig("APP_SALSA") + Utility.JsonSerialize_IgnoreLoopingReference(DTO.GetSignatureDTO()));
dynamic validationResult = new ExpandoObject();
List <string> FrqValues = new List <string>();
PxStat.RequestLanguage.LngIsoCode = DTO.LngIsoCode;
bool isValid = false;
isValid = Validate();
// }
if (isValid)
{
validationResult.Signature = signature;
validationResult.FrqValueCandidate = FrqValues;
Response.data = validationResult;
return(true);
}
if (!isValid)
{
if (MatrixData != null)
{
if (MatrixData.MainSpec.requiresResponse)
{
//cancel any validation errors and return an object to enable the user to choose which should be the time dimension
Matrix.Specification langSpec = MatrixData.GetSpecFromLanguage(DTO.LngIsoCode);
if (langSpec == null)
{
langSpec = MatrixData.MainSpec;
}
foreach (var v in langSpec.MainValues)
{
FrqValues.Add(v.Key);
}
validationResult.Signature = null;
validationResult.FrqValueCandidate = FrqValues;
Response.data = validationResult;
return(true);
}
}
Response.data = validationResult;
return(false);
}
//Response.error = Label.Get("error.validation");
return(false);
}
public void CopyTo(DTO other)
{
other.Number = this.Number;
other.X = this.X;
other.Y = this.Y;
}
public void FillFromDTO(DTO source)
{
Number = source.Number;
X = source.X;
Y = source.Y;
}
/// <summary>
/// 获取指定店铺的友情链接信息集合
/// </summary>
/// <param name="shopid">店铺id</param>
/// <returns>友情链接信息集合</returns>
public static ShoplinkinfoCollection GetShopLinkByShopId(int shopId)
{
return(DTO.GetShopLinkList(DbProvider.GetInstance().GetShopLinkByShopId(shopId)));
}
/// <summary>
/// 获取指定商品交易日志id的交易信息
/// </summary>
/// <param name="goodstradelogid">商品交易日志id</param>
/// <returns>交易信息</returns>
public static Goodstradeloginfo GetGoodsTradeLogInfo(int goodsTradeLogId)
{
return(DTO.GetGoodsTradeLogInfo(DbProvider.GetInstance().GetGoodsTradeLogByID(goodsTradeLogId)));
}
public bool CompareTo(DTO Target)
{
return(Target.Value == Value);
}
/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
dynamic result = new ExpandoObject();
//This is required for validation in the Matrix code, but is not used for px build
Request.parameters.GrpCode = Utility.GetCustomConfig("APP_DEFAULT_GROUP");
//This is required for validation in the Matrix code, but is not used for px build
Request.parameters.GrpCode = Utility.GetCustomConfig("APP_DEFAULT_GROUP");
Request.parameters.source = Utility.GetCustomConfig("APP_DEFAULT_SOURCE");
//We get the PxDocument from the validator
PxValidator pxValidator = new PxValidator();
PxDocument PxDoc = pxValidator.ParsePxFile(DTO.MtrInput);
if (!pxValidator.ParseValidatorResult.IsValid)
{
Response.error = Error.GetValidationFailure(pxValidator.ParseValidatorResult.Errors);
return(false);
}
Matrix theMatrixData;
theMatrixData = new Matrix(PxDoc, DTO.FrqCodeTimeval ?? "", DTO.FrqValueTimeval ?? "");
var signature = Utility.GetMD5(Utility.GetCustomConfig("APP_SALSA") + Utility.JsonSerialize_IgnoreLoopingReference(DTO.GetSignatureDTO()));
if (signature != DTO.Signature)
{
Response.error = Label.Get("error.validation");
return(false);
}
Build_BSO pBso = new Build_BSO();
result.FrqValue = "";
result.template = pBso.GetCsvTemplate(theMatrixData, DTO.LngIsoCode, DTO.FrqCodeTimeval);
result.MtrCode = theMatrixData.Code;
Response.data = result;
return(true);
}
/// <summary>
/// 根据交易单的流水号来获取交易信息
/// </summary>
/// <param name="tradeno">交易单的流水号</param>
/// <returns>交易信息</returns>
public static Goodstradeloginfo GetGoodsTradeLogInfo(string tradeNo)
{
return(DTO.GetGoodsTradeLogInfo(DbProvider.GetInstance().GetGoodsTradeLogByTradeNo(tradeNo)));
}
private void Initialize()
{
dto = new DTO();
bentzer = new List <Benutzer>();
}
static string SerializeMessages(DTO message)
{
return(JsonConvert.SerializeObject(message));
}
private VisaCheckOut.Models.DTO <VisaCheckOut.Models.VisaCheckoutOutputs.UserOut.MerchantUsersDTO> SaveMerchantUser(CreateMerchantUserInp inp)
{
VisaCheckOut.Models.DTO <VisaCheckOut.Models.VisaCheckoutOutputs.UserOut.MerchantUsersDTO> dto = new DTO <MerchantUsersDTO>();
string useriD = System.Web.HttpContext.Current.User.Identity.GetUserId();
dto.objname = "CreateMerchantUser";
string merchantid = "";
string merchantname = "";
int merchantuserid = 0;
string username = "";
try
{
if (string.IsNullOrEmpty(inp.MerchantID) || string.IsNullOrEmpty(inp.UserID))
{
dto.status = new Models.Status(5);
return(dto);
}
merchantid = inp.MerchantID;
username = inp.UserName;
var getusername = ve.MerchantUsers.Where(a => a.UserID == inp.UserID).FirstOrDefault();
if (getusername != null)
{
username = getusername.UserName;
}
if (!string.IsNullOrEmpty(inp.MerchantUserID))
{
merchantuserid = Convert.ToInt32(inp.MerchantUserID);
var getchkusr = ve.MerchantUsers.Where(a => a.UserID == inp.UserID && a.ID != merchantuserid).FirstOrDefault();
if (getchkusr == null)
{
var getbllrchkusr = ve.MerchantUsers.Where(a => a.UserID == inp.UserID && a.MerchantID == merchantid && a.ID != merchantuserid).FirstOrDefault();
if (getbllrchkusr != null)
{
dto.status = new Models.Status(6);
dto.status.statusdescription = "Merchant with same User" + " " + dto.status.statusdescription;
return(dto);
}
}
else
{
var getbllrchkusr = ve.MerchantUsers.Where(a => a.ID != merchantuserid && a.MerchantID == merchantid && a.UserID == inp.UserID).FirstOrDefault();
if (getbllrchkusr != null)
{
dto.status = new Models.Status(6);
dto.status.statusdescription = "Merchant with same User" + " " + dto.status.statusdescription;
return(dto);
}
else
{
var getbllrchkusr1 = ve.MerchantUsers.Where(a => a.ID != merchantuserid && a.UserID == inp.UserID && a.MerchantID != merchantid).FirstOrDefault();
if (getbllrchkusr1 != null)
{
dto.status = new Models.Status(6);
dto.status.statusdescription = "User was already assigned to another Merchant";
return(dto);
}
else
{
dto.status = new Models.Status(6);
dto.status.statusdescription = "User was already assigned to another Merchant";
return(dto);
}
}
}
}
else
{
var getchkusr = ve.MerchantUsers.Where(a => a.UserID == inp.UserID).FirstOrDefault();
if (getchkusr == null)
{
var getbllrchkusr = ve.MerchantUsers.Where(a => a.UserID == inp.UserID && a.MerchantID == merchantid).FirstOrDefault();
if (getbllrchkusr != null)
{
dto.status = new Models.Status(6);
dto.status.statusdescription = "Merchant with same User" + " " + dto.status.statusdescription;
return(dto);
}
}
else
{
var getbllrchkusr = ve.MerchantUsers.Where(a => a.MerchantID == merchantid && a.UserID == inp.UserID).FirstOrDefault();
if (getbllrchkusr != null)
{
dto.status = new Models.Status(6);
dto.status.statusdescription = "Merchant with same User" + " " + dto.status.statusdescription;
return(dto);
}
else
{
var getbllrchkusr1 = ve.MerchantUsers.Where(a => a.MerchantID != merchantid && a.UserID == inp.UserID).FirstOrDefault();
if (getbllrchkusr1 != null)
{
dto.status = new Models.Status(6);
dto.status.statusdescription = "User was already assigned to another Merchant";
return(dto);
}
else
{
dto.status = new Models.Status(6);
dto.status.statusdescription = "User was already assigned to another Merchant";
return(dto);
}
}
}
}
if (!string.IsNullOrEmpty(inp.MerchantUserID))
{
merchantid = inp.MerchantID;
var getmerchantuser = ve.MerchantUsers.Where(a => a.ID == merchantuserid).FirstOrDefault();
if (getmerchantuser != null)
{
getmerchantuser.MerchantID = merchantid;
getmerchantuser.UserID = inp.UserID;
getmerchantuser.MerchantName = inp.MerchantName;
getmerchantuser.UserName = username;
getmerchantuser.UpdatedDate = DateTime.Now;
getmerchantuser.UpdatedBy = useriD;
dto.status = new Models.Status();
dto.status.statuscode = "200";
dto.status.statusdescription = "OK";
}
}
else
{
var getmerchanname = ve.Merchants.Where(a => a.MerchantId == merchantid).FirstOrDefault();
merchantname = getmerchanname.CompanyPrimaryLegalName;
if (getmerchanname != null)
{
MerchantUser muser = new MerchantUser();
muser.MerchantID = merchantid;
muser.MerchantName = merchantname;
muser.UserID = inp.UserID;
muser.UserName = username;
muser.Status = true;
muser.CreatedDate = DateTime.Now;
muser.UpdatedDate = DateTime.Now;
ve.MerchantUsers.Add(muser);
ve.SaveChanges();
dto.status = new Models.Status();
dto.status.statuscode = "200";
dto.status.statusdescription = "OK";
}
}
}
catch (Exception ex)
{
Common.TraceLog.WriteToLog(ex.Message.ToString() + "Trace = " + ex.StackTrace.ToString(), ex);
}
dto.status = new Models.Status(0);
return(dto);
}
public void SetValue(ProjectDescriptor descriptor)
{
this.name = descriptor.name.GetValue();
this.version = descriptor.version.GetValue();
this.syncher = descriptor.syncher.ToDTO();
}
public async Task <IHttpActionResult> CreateUser(CreateUserBindingModel createUserModel)
{
VisaCheckOut.Models.DTO <VisaCheckOut.Models.VisaCheckoutOutputs.UserOut.UserDTO> dto = new DTO <Models.VisaCheckoutOutputs.UserOut.UserDTO>();
dto.objname = "createuser";
string useriD = System.Web.HttpContext.Current.User.Identity.GetUserId();
if (string.IsNullOrEmpty(createUserModel.FirstName) || string.IsNullOrEmpty(createUserModel.LastName) || string.IsNullOrEmpty(createUserModel.Username) || string.IsNullOrEmpty(createUserModel.Email))
{
dto.status = new VisaCheckOut.Models.Status(5);
return(Ok(dto));
}
if (string.IsNullOrEmpty(createUserModel.Userid) && string.IsNullOrEmpty(createUserModel.Password))
{
dto.status = new VisaCheckOut.Models.Status(5);
return(Ok(dto));
}
else
{
if (!string.IsNullOrEmpty(createUserModel.Userid))
{
var euser = await this.AppUserManager.FindByIdAsync(createUserModel.Userid);
if (euser == null)
{
dto.status = new VisaCheckOut.Models.Status(7);
dto.status.statusdescription = "User" + " " + dto.status.statusdescription;
return(Ok(dto));
}
if (euser.Email != createUserModel.Email)
{
var users = this.AppUserManager.Users.Where(a => a.Email.ToLower() == createUserModel.Email.ToLower()).FirstOrDefault();
if (users != null)
{
dto.status = new VisaCheckOut.Models.Status(6);
dto.status.statusdescription = "Email ID" + " " + dto.status.statusdescription;
return(Ok(dto));
}
}
if (euser.UserName != createUserModel.Username)
{
var users = this.AppUserManager.Users.Where(a => a.UserName.ToLower() == createUserModel.Username.ToLower()).FirstOrDefault();
if (users != null)
{
dto.status = new VisaCheckOut.Models.Status(6);
dto.status.statusdescription = "User Name" + " " + dto.status.statusdescription;
return(Ok(dto));
}
}
}
else
{
var users = this.AppUserManager.Users.Where(a => a.UserName.ToLower() == createUserModel.Username.ToLower()).FirstOrDefault();
if (users != null)
{
dto.status = new VisaCheckOut.Models.Status(6);
dto.status.statusdescription = "User Name" + " " + dto.status.statusdescription;
return(Ok(dto));
}
if (!string.IsNullOrEmpty(createUserModel.Email))
{
var euserss = this.AppUserManager.Users.Where(a => a.Email.ToLower() == createUserModel.Email.ToLower()).FirstOrDefault();
if (euserss != null)
{
if (euserss.Email.ToLower() == createUserModel.Email.ToLower())
{
dto.status = new VisaCheckOut.Models.Status(6);
dto.status.statusdescription = "Email ID" + " " + dto.status.statusdescription;
return(Ok(dto));
}
}
}
}
}
if (!string.IsNullOrEmpty(createUserModel.Userid))
{
var users = await this.AppUserManager.FindByIdAsync(createUserModel.Userid);
if (users != null)
{
users.UserName = createUserModel.Username;
users.Email = createUserModel.Email;
users.FirstName = createUserModel.FirstName;
users.LastName = createUserModel.LastName;
users.PhoneNumber = createUserModel.PhoneNumber;
users.Level = 3;
users.EmailConfirmed = true;
users.JoinDate = users.JoinDate;
users.CreatedDate = users.CreatedDate;
users.UpdatedDate = DateTime.Now;
}
IdentityResult addUserResul = await this.AppUserManager.UpdateAsync(users);
if (!addUserResul.Succeeded)
{
return(GetErrorResult(addUserResul));
}
dto.status = new Status();
dto.status.statuscode = "200";
dto.status.statusdescription = "OK";
return(Ok(dto));
}
else
{
var user = new ApplicationUser()
{
UserName = createUserModel.Username,
Email = createUserModel.Email,
FirstName = createUserModel.FirstName,
LastName = createUserModel.LastName,
PhoneNumber = createUserModel.PhoneNumber,
Level = 3,
EmailConfirmed = true,
Status = true,
JoinDate = DateTime.Now,
CreatedDate = DateTime.Now,
UpdatedDate = DateTime.Now
};
IdentityResult addUserResult = await this.AppUserManager.CreateAsync(user, createUserModel.Password);
if (!addUserResult.Succeeded)
{
return(GetErrorResult(addUserResult));
}
// string code = await this.AppUserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// var callbackUrl = new Uri(Url.Link("ConfirmEmailRoute", new { userId = user.Id, code = code }));
// await this.AppUserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
// Uri locationHeader = new Uri(Url.Link("GetUserById", new { id = user.Id }));
dto.status = new Status();
dto.status.statuscode = "200";
dto.status.statusdescription = "OK";
return(Ok(dto));
}
}
public IActionResult Index(DTO model = null)
{
return(View(model));
}
private void button_anzeigen_Click(object sender, RoutedEventArgs e)
{
DTO dto = new DTO();
dataGrid.ItemsSource = dto.GetAllCustomers();
}
public async Task <IHttpActionResult> CreateMerchantUser(Models.VisaCheckoutInputs.UserManagementInp.CreateMerchantUserInp inp)
{
string mid = inp.MerchantID;
VisaCheckOut.Models.DTO <VisaCheckOut.Models.VisaCheckoutOutputs.UserOut.MerchantUsersDTO> dto = new DTO <MerchantUsersDTO>();
var merchantname = ve.Merchants.Where(a => a.MerchantId == mid).FirstOrDefault();
var getusers = this.AppUserManager.FindById(inp.UserID);
try
{
if (merchantname != null)
{
inp.MerchantName = merchantname.CompanyPrimaryLegalName;
}
if (getusers != null)
{
inp.UserName = getusers.UserName;
}
dto = SaveMerchantUser(inp);
}
catch (HttpRequestException e)
{
}
return(Ok(dto));
}
