public HttpResponseMessage GetLogoByID(Int64 providerID)
{
var result =
new HttpResponseMessage(HttpStatusCode.OK);
CRUDOperation cRUDOperation = new CRUDOperation();
tbl_Provider provider = cRUDOperation.GetProviderById(providerID);
// 1) Get file bytes
var fileBytes = File.ReadAllBytes(provider.LogoLinkPath);
// 2) Add bytes to a memory stream
var fileMemStream =
new MemoryStream(fileBytes);
// 3) Add memory stream to response
result.Content = new StreamContent(fileMemStream);
// 4) build response headers
var headers = result.Content.Headers;
headers.ContentDisposition =
new ContentDispositionHeaderValue("attachment");
headers.ContentDisposition.FileName = provider.LogoLinkName;
headers.ContentType =
new MediaTypeHeaderValue("application/jpg");
//new MediaTypeHeaderValue("application/octet-stream");
headers.ContentLength = fileMemStream.Length;
return(result);
}
public IHttpActionResult UpdateProvider(tbl_Provider item)
{
CRUDOperation operation = new CRUDOperation();
if (item == null)
{
return(NotFound());
}
else
{
var dbitem = operation.UpdateProvider(item);
return(Ok(dbitem));
}
}
public IHttpActionResult GetProviderByID(Int64 id)
{
ProviderBusinessOperation businessOperation = new ProviderBusinessOperation();
tbl_Provider itemOut = null;
BaseOutput baseOutput = businessOperation.GetProviderByID(id, out itemOut);
if (baseOutput.ResultCode == 1)
{
return(Ok(itemOut));
}
else
{
return(Content(HttpStatusCode.BadRequest, baseOutput));
}
}
public BaseOutput GetProviderByID(Int64 id, out tbl_Provider itemOut)
{
BaseOutput baseOutput;
CRUDOperation operation = new CRUDOperation();
itemOut = null;
try
{
var provider = operation.GetProviderById(id);
itemOut = provider;
return(baseOutput = new BaseOutput(true, BOResultTypes.Success.GetHashCode(), BOBaseOutputResponse.SuccessResponse, ""));
}
catch (Exception ex)
{
itemOut = null;
return(baseOutput = new BaseOutput(false, BOResultTypes.Danger.GetHashCode(), BOBaseOutputResponse.DangerResponse, ex.Message));
}
}
public BaseOutput DeleteProvider(Int64 providerID, out tbl_Provider itemOut)
{
CRUDOperation cRUDOperation = new CRUDOperation();
BaseOutput baseOutput;
itemOut = null;
try
{
tbl_Provider _propvider = cRUDOperation.GetProviderById(providerID);
if (_propvider != null)
{
List <tbl_Proposal> _Proposals = cRUDOperation.GetProposalsByProviderID(_propvider.ID);
if (_Proposals.Count > 0)
{
return(baseOutput = new BaseOutput(false, CustomError.ProposalRecordExistErrorCode, CustomError.ProposalRecordExistErrorDesc, "Bu provayder`a bağlı xidmətlər mövcuddur!."));
}
else
{
tbl_User _user = cRUDOperation.DeleteUser(_propvider.UserId, _propvider.UserId);
if (_user == null)
{
return(baseOutput = new BaseOutput(false, CustomError.NotExistRecordErrorCode, CustomError.NotExistRecordErrorDesc, ""));
}
tbl_Provider _ProviderDB = cRUDOperation.DeleteProvider(_propvider.ID, _user.ID);
itemOut = _ProviderDB;
return(baseOutput = new BaseOutput(true, BOResultTypes.Success.GetHashCode(), BOBaseOutputResponse.SuccessResponse, ""));
}
}
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));
}
}
public HttpResponseMessage UploadLogo()
{
Int64 providerID = HttpContext.Current.Request.Form["providerID"] == null ? 0 : Int64.Parse(HttpContext.Current.Request.Form["providerID"]);
var file = HttpContext.Current.Request.Files.Count > 0 ?
HttpContext.Current.Request.Files[0] : null;
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
string logoPath = ServerPath + @"\logo";
if (!Directory.Exists(logoPath))
{
Directory.CreateDirectory(logoPath);
}
string fullPath = Path.Combine(logoPath, fileName);
file.SaveAs(fullPath);
tbl_Provider provider = new tbl_Provider()
{
LogoLinkName = fileName,
LogoLinkPath = fullPath,
ID = providerID,
UpdateUser = 0
};
CRUDOperation cRUDOperation = new CRUDOperation();
tbl_Provider providerDB = cRUDOperation.UpdateLogoPic(provider);
if (providerDB != null)
{
var message1 = string.Format("Image Updated Successfully.");
return(Request.CreateResponse(HttpStatusCode.Created, message1));
}
}
return(Request.CreateResponse(HttpStatusCode.NoContent));
}
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 GenarateOTP(string userName, out string itemOut)
{
CRUDOperation cRUDOperation = new CRUDOperation();
BaseOutput baseOutput;
try
{
if (string.IsNullOrEmpty(userName))
{
itemOut = null;
return(baseOutput = new BaseOutput(true, CustomError.EmptyUserNameErrorCode, CustomError.EmptyUserNameErrorDesc, ""));
}
tbl_User user = cRUDOperation.GetUserByUserName(userName);
if (user == null)
{
itemOut = null;
return(baseOutput = new BaseOutput(true, CustomError.UserNameNotFoundCode, CustomError.UserNameNotFoundDesc, ""));
}
else
{
string phoneNumber = string.Empty;
if (user.UserType_EVID == (long)UserType.Customer)
{
phoneNumber = userName;
}
else if (user.UserType_EVID == (long)UserType.Provider)
{
tbl_Provider customer = cRUDOperation.GetProviderByUserName(user.UserName);
phoneNumber = customer.RelatedPersonPhone;
}
else if (user.UserType_EVID == (long)UserType.ProviderBranch)
{
tbl_Provider customer = cRUDOperation.GetProviderByUserName(user.UserName);
phoneNumber = customer.RelatedPersonPhone;
}
if (string.IsNullOrEmpty(phoneNumber))
{
itemOut = null;
return(baseOutput = new BaseOutput(true, CustomError.PhoneNumberErrorCode, CustomError.PhoneNumberErrorDesc, ""));
}
else
{
byte[] bytes = System.Text.Encoding.UTF8.GetBytes(userName);
var window = new VerificationWindow(previous: 1, future: 1);
var totp = new Totp(bytes, step: 300);
var result = totp.ComputeTotp(DateTime.UtcNow);
poctgoyerciniSRV.smsservice srv = new poctgoyerciniSRV.smsservice();
List <string> lists = new List <string>();
string[] numbers = new string[1];
numbers[0] = phoneNumber;
string[] resultArray = new string[1];
resultArray = srv.SmsInsert_1_N(WebServiceUtil.SMSUserName, WebServiceUtil.SMSPassword, DateTime.Now, null, numbers, result);
if (!string.IsNullOrEmpty(resultArray[0]))
{
tbl_OTP _OTP = new tbl_OTP()
{
UserID = user.ID,
PhoneNumber = phoneNumber,
CreateTime = DateTime.Now,
OTPCode = result,
ISsuccess = 0,
};
tbl_OTP oTP = cRUDOperation.AddOTP(_OTP);
itemOut = _OTP.OTPCode;
return(baseOutput = new BaseOutput(true, BOResultTypes.Success.GetHashCode(), BOBaseOutputResponse.SuccessResponse, ""));
}
else
{
itemOut = null;
return(baseOutput = new BaseOutput(true, CustomError.OTPCodeNotSendSMSServiceCode, CustomError.OTPCodeNotSendSMSServiceDesc, ""));
}
}
}
}
catch (Exception ex)
{
throw;
}
}
public BaseOutput VerifyOTP(string userName, string otptext, out bool verify)
{
CRUDOperation cRUDOperation = new CRUDOperation();
BaseOutput baseOutput;
try
{
if (string.IsNullOrEmpty(userName))
{
verify = false;
return(baseOutput = new BaseOutput(true, CustomError.EmptyUserNameErrorCode, CustomError.EmptyUserNameErrorDesc, ""));
}
else if (string.IsNullOrEmpty(otptext))
{
verify = false;
return(baseOutput = new BaseOutput(true, CustomError.EmptyOTPCodeErrorCode, CustomError.EmptyOTPCodeErrorDesc, ""));
}
tbl_User user = cRUDOperation.GetUserByUserName(userName);
if (user == null)
{
verify = false;
return(baseOutput = new BaseOutput(true, CustomError.UserNameNotFoundCode, CustomError.UserNameNotFoundDesc, ""));
}
else
{
string phoneNumber = string.Empty;
if (user.UserType_EVID == (long)UserType.Customer)
{
phoneNumber = userName;
}
else if (user.UserType_EVID == (long)UserType.Provider)
{
tbl_Provider customer = cRUDOperation.GetProviderByUserName(user.UserName);
phoneNumber = customer.RelatedPersonPhone;
}
else if (user.UserType_EVID == (long)UserType.ProviderBranch)
{
tbl_Provider customer = cRUDOperation.GetProviderByUserName(user.UserName);
phoneNumber = customer.RelatedPersonPhone;
}
if (string.IsNullOrEmpty(phoneNumber))
{
verify = false;
return(baseOutput = new BaseOutput(true, CustomError.PhoneNumberErrorCode, CustomError.PhoneNumberErrorDesc, ""));
}
byte[] bytes = System.Text.Encoding.UTF8.GetBytes(userName);
var totp = new Totp(bytes, step: 300);
var input = otptext;
long timeStepMatched;
verify = totp.VerifyTotp(input, out timeStepMatched, window: null);
tbl_OTP OTPObj = cRUDOperation.GetOTPByOtpCode(otptext, phoneNumber);
if (verify)
{
OTPObj.ISsuccess = 1;
tbl_OTP OTPupdate = cRUDOperation.UpdateOTP(OTPObj);
}
else
{
OTPObj.ISsuccess = 2;
tbl_OTP OTPupdate = cRUDOperation.UpdateOTP(OTPObj);
}
return(baseOutput = new BaseOutput(true, BOResultTypes.Success.GetHashCode(), BOBaseOutputResponse.SuccessResponse, ""));
}
}
catch (Exception)
{
throw;
}
}
