public IHttpActionResult AddEnumValue(tbl_EnumValue item)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
CRUDOperation operation = new CRUDOperation();
tbl_EnumValue dbitem = operation.AddEnumValue(item);
return(Ok(dbitem));
}
public IHttpActionResult UpdateEnumValue(tbl_EnumValue item)
{
CRUDOperation operation = new CRUDOperation();
if (item == null)
{
return(NotFound());
}
else
{
var dbitem = operation.UpdateEnumValue(item);
return(Ok(dbitem));
}
}
public ActionResult Edit(int id)
{
EnumVM viewModel = new EnumVM();
viewModel = poulateDropDownList(viewModel);
CRUDOperation dataOperations = new CRUDOperation();
tbl_EnumValue tblItem = dataOperations.GetEnumValueById(id);
viewModel.EnumValueID = id;
viewModel.EnumCategoryID = tblItem.EnumCategoryID == null?0:(Int64)tblItem.EnumCategoryID;
viewModel.EnumValueCode = tblItem.Code;
viewModel.EnumValueName = tblItem.Name;
viewModel.EnumValueDesc = tblItem.Description;
return(View(viewModel));
}
public ActionResult Edit(EnumVM viewModel)
{
try
{
var UserProfile = (UserProfileSessionData)this.Session["UserProfile"];
if (UserProfile != null)
{
if (ModelState.IsValid)
{
tbl_EnumValue item = new tbl_EnumValue()
{
ID = viewModel.EnumValueID,
EnumCategoryID = viewModel.EnumCategoryID,
Code = viewModel.EnumValueCode,
Name = viewModel.EnumValueName,
Description = viewModel.EnumValueDesc,
UpdateDate = DateTime.Now,
UpdateUser = UserProfile.UserId
};
CRUDOperation dataOperations = new CRUDOperation();
tbl_EnumValue dbItem = dataOperations.UpdateEnumValue(item);
if (dbItem != null)
{
TempData["success"] = "Ok";
TempData["message"] = "Məlumatlar uğurla dəyişdirildi";
return(RedirectToAction("Index"));
}
else
{
TempData["success"] = "notOk";
TempData["message"] = "Məlumatlar dəyişdirilərkən xəta baş verdi";
return(RedirectToAction("Index"));
}
}
}
throw new ApplicationException("Invalid model");
}
catch (ApplicationException ex)
{
viewModel = poulateDropDownList(viewModel);
return(View(viewModel));
}
}
public ActionResult Create(EnumVM viewModel)
{
try
{
var UserProfile = (UserProfileSessionData)this.Session["UserProfile"];
if (UserProfile != null)
{
tbl_EnumValue item = new tbl_EnumValue()
{
EnumCategoryID = viewModel.EnumCategoryID,
Code = viewModel.EnumValueCode,
Name = viewModel.EnumValueName,
Description = viewModel.EnumValueDesc,
InsertDate = DateTime.Now,
InsertUser = UserProfile.UserId
};
CRUDOperation dataOperations = new CRUDOperation();
tbl_EnumValue dbItem = dataOperations.AddEnumValue(item);
if (dbItem != null)
{
TempData["success"] = "Ok";
TempData["message"] = "Məlumatlar uğurla əlavə olundu";
return(RedirectToAction("Index"));
}
else
{
TempData["success"] = "notOk";
TempData["message"] = "Məlumatlar əlavə olunarkən xəta baş verdi";
return(RedirectToAction("Index"));
}
}
}
catch (ApplicationException ex)
{
viewModel = poulateDropDownList(viewModel);
return(View(viewModel));
}
throw new ApplicationException("Invalid model");
}
public ActionResult Edit(int id)
{
OperatorInformationVM viewModel = new OperatorInformationVM();
CRUDOperation dataOperations = new CRUDOperation();
tbl_OperatorInformation tblItem = dataOperations.GetOperatorInformationById(id);
tbl_EnumValue enumValue = dataOperations.GetEnumValueById((int)tblItem.OperatorChanelType_EVID);
viewModel.EnumCategoryID = enumValue.EnumCategoryID;
viewModel = poulateDropDownList(viewModel);
viewModel.ID = id;
viewModel.OperatorTypeEVID = tblItem.OperatorType_EVID == null?0:(int)tblItem.OperatorType_EVID;
viewModel.Name = tblItem.Name;
viewModel.OperatorChanelTypeEVID = tblItem.OperatorChanelType_EVID == null ? 0 : (int)tblItem.OperatorChanelType_EVID;
viewModel.InOutTypeEVID = tblItem.InOutType_EVID == null ? 0 : (int)tblItem.InOutType_EVID;
viewModel.Price = tblItem.Price == null?0:(decimal)tblItem.Price;
viewModel.Point = tblItem.Point == null ? 0 : (decimal)tblItem.Point;
return(View(viewModel));
}
public BaseOutput AddProviderWithUser(Provider item, out Provider itemOut)
{
CRUDOperation cRUDOperation = new CRUDOperation();
BaseOutput baseOutput;
try
{
if ((string.IsNullOrEmpty(item.VOEN)) || (item.VOEN.Length != 10))
{
itemOut = null;
return(baseOutput = new BaseOutput(true, CustomError.VOENNotStandartErrorCode, CustomError.VOENNotStandartErrorDesc, ""));
}
tbl_EnumValue enumValue = cRUDOperation.GetEnumValueByName("Provider");
tbl_User user = new tbl_User()
{
UserName = item.UserName,
Password = UserUtil.MD5HashedPassword(item.Password),
UserType_EVID = enumValue.ID,
};
tbl_User _User = cRUDOperation.GetUserByUserName(user.UserName);
if (_User == null)
{
tbl_Provider providerVoen = cRUDOperation.GetProviderByVOEN(item.VOEN);
if (providerVoen != null)
{
itemOut = null;
return(baseOutput = new BaseOutput(true, CustomError.UniqueVOENErrorCode, CustomError.UniqueVOENErrorDesc, ""));
}
tbl_User userDB = cRUDOperation.AddUser(user);
if (userDB != null)
{
tbl_Provider provider = new tbl_Provider()
{
UserId = userDB.ID,
Name = item.Name,
Type = item.Type,
Description = item.Description,
RegionId = item.RegionId,
Address = item.Address,
RelatedPersonName = item.RelatedPersonName,
RelatedPersonPhone = item.RelatedPersonPhone,
RelatedPersonProfession = item.RelatedPersonProfession,
RP_HomePhone = item.RP_HomePhone,
VOEN = item.VOEN,
ParentID = item.ParentID
};
tbl_Provider providerDB = cRUDOperation.AddProvider(provider);
if (providerDB != null)
{
itemOut = new Provider()
{
UserID = providerDB.UserId,
UserName = userDB.UserName,
ID = providerDB.ID,
ParentID = providerDB.ParentID,
Name = providerDB.Name,
Type = providerDB.Type == null ? 0 : (Int64)providerDB.Type,
Description = providerDB.Description,
RegionId = providerDB.RegionId == null ? 0 : (Int64)providerDB.RegionId,
RelatedPersonName = providerDB.RelatedPersonName,
RelatedPersonPhone = providerDB.RelatedPersonPhone,
RelatedPersonProfession = providerDB.RelatedPersonProfession,
RP_HomePhone = providerDB.RP_HomePhone,
VOEN = providerDB.VOEN
};
return(baseOutput = new BaseOutput(true, BOResultTypes.Success.GetHashCode(), BOBaseOutputResponse.SuccessResponse, ""));
}
else
{
itemOut = null;
return(baseOutput = new BaseOutput(true, BOResultTypes.Danger.GetHashCode(), BOBaseOutputResponse.DangerResponse, ""));
}
}
else
{
itemOut = null;
return(baseOutput = new BaseOutput(true, BOResultTypes.Danger.GetHashCode(), BOBaseOutputResponse.DangerResponse, ""));
}
}
else
{
itemOut = null;
return(baseOutput = new BaseOutput(true, BOResultTypes.Danger.GetHashCode(), BOBaseOutputResponse.DangerResponse, ""));
}
}
catch (Exception ex)
{
itemOut = null;
return(baseOutput = new BaseOutput(false, BOResultTypes.Danger.GetHashCode(), BOBaseOutputResponse.DangerResponse, ex.Message));
}
}
public BaseOutput AddCustomerWithUser(Customer item, out Customer itemOut)
{
CRUDOperation cRUDOperation = new CRUDOperation();
BaseOutput baseOutput;
itemOut = null;
try
{
tbl_EnumValue enumValue = cRUDOperation.GetEnumValueByName("Customer");
tbl_User user = new tbl_User()
{
UserName = item.UserName,
Password = UserUtil.MD5HashedPassword(item.Password),
UserType_EVID = enumValue.ID,
};
tbl_User _User = cRUDOperation.GetUserByUserName(user.UserName);
if (_User == null)
{
tbl_User userDB = cRUDOperation.AddUser(user);
if (userDB != null)
{
tbl_Customer customer = new tbl_Customer()
{
UserId = userDB.ID,
Name = item.Name,
Surname = item.Surname,
FatherName = item.FatherName,
IdentityCode = item.IdentityCode,
PhoneNumber = item.PhoneNumber,
Email = item.Email,
RegionId = item.RegionId,
Address = item.Address
};
tbl_Customer customerDB = cRUDOperation.AddCustomer(customer);
if (customerDB != null)
{
itemOut = new Customer()
{
UserID = customerDB.UserId,
UserName = userDB.UserName,
CustomerID = customerDB.ID,
Name = customerDB.Name,
Surname = customerDB.Surname,
FatherName = customerDB.FatherName,
IdentityCode = customerDB.IdentityCode,
PhoneNumber = customerDB.PhoneNumber,
Email = customerDB.Email,
RegionId = customerDB.RegionId == null ? 0 : (Int64)customerDB.RegionId,
Address = customerDB.Address
};
}
}
}
return(baseOutput = new BaseOutput(true, BOResultTypes.Success.GetHashCode(), BOBaseOutputResponse.SuccessResponse, ""));
}
catch (Exception ex)
{
return(baseOutput = new BaseOutput(false, BOResultTypes.Danger.GetHashCode(), BOBaseOutputResponse.DangerResponse, ex.Message));
}
}
