public int SaveOrgnization(TenantDetailsBO Orgnization)
{
int orgni = 0;
try
{
using (SqlConnection sqlCon = new SqlConnection(Constant.DBConnectionString))
{
using (SqlCommand sqlCmd = new SqlCommand("sspSaveOrgnization", sqlCon))
{
sqlCon.Open();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new SqlParameter("@TenantRegNo", Orgnization.OrgRegNo));
sqlCmd.Parameters.Add(new SqlParameter("@Address1", Orgnization.Address1));
sqlCmd.Parameters.Add(new SqlParameter("@PrimaryPhone", Orgnization.PrimaryPhone));
sqlCmd.Parameters.Add(new SqlParameter("@Country", Orgnization.Country));
sqlCmd.Parameters.Add(new SqlParameter("@AlternatePhone", Orgnization.AlternatePhone));
sqlCmd.Parameters.Add(new SqlParameter("@Email", Orgnization.Email));
sqlCmd.Parameters.Add(new SqlParameter("@Fax", Orgnization.Fax));
sqlCmd.Parameters.Add(new SqlParameter("@TenantID", Orgnization.TenantID));
sqlCmd.Parameters.Add(new SqlParameter("@Logo", Orgnization.Logo));
SqlDataReader reader = sqlCmd.ExecuteReader();
reader.Close();
reader = null;
}
sqlCon.Close();
}
}
catch (Exception ex)
{
strErrorMsg = ex.Message;
throw;
}
return(orgni);
}
public TenantDetailsBO getTenantDetails(int TenantID)
{
TenantDetailsBO tenantDetBO = new TenantDetailsBO();
using (SqlConnection connection = new SqlConnection(Constant.DBConnectionString))
{
SqlCommand command = new SqlCommand("select * from tblTenantProfile where TenantID = @TenantID", connection);
{
command.Parameters.Add(new SqlParameter("@TenantID", TenantID));
command.CommandType = CommandType.Text;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
tenantDetBO.TenantCode = reader["TenantCode"] == DBNull.Value ? string.Empty : Convert.ToString(reader["TenantCode"]);
tenantDetBO.TenantName = reader["TenantName"] == DBNull.Value ? string.Empty : Convert.ToString(reader["TenantName"]);
tenantDetBO.TenantType = reader["TenantType"] == DBNull.Value ? string.Empty : Convert.ToString(reader["TenantType"]);
tenantDetBO.ParentTenantID = reader["ParentTenantID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["ParentTenantID"]);
tenantDetBO.TaxID = reader["TaxID"] == DBNull.Value ? string.Empty : Convert.ToString(reader["TaxID"]);
tenantDetBO.InCorpState = reader["InCorpState"] == DBNull.Value ? string.Empty : Convert.ToString(reader["InCorpState"]);
tenantDetBO.Address1 = reader["Address1"] == DBNull.Value ? string.Empty : Convert.ToString(reader["Address1"]);
tenantDetBO.Address2 = reader["Address2"] == DBNull.Value ? string.Empty : Convert.ToString(reader["Address2"]);
tenantDetBO.City = reader["City"] == DBNull.Value ? string.Empty : Convert.ToString(reader["City"]);
tenantDetBO.State = reader["State"] == DBNull.Value ? string.Empty : Convert.ToString(reader["State"]);
tenantDetBO.Zip = reader["Zip"] == DBNull.Value ? string.Empty : Convert.ToString(reader["Zip"]);
tenantDetBO.Country = reader["Country"] == DBNull.Value ? string.Empty : Convert.ToString(reader["Country"]);
tenantDetBO.Website = reader["Website"] == DBNull.Value ? string.Empty : Convert.ToString(reader["Website"]);
tenantDetBO.PrimaryPhone = reader["PrimaryPhone"] == DBNull.Value ? string.Empty : Convert.ToString(reader["PrimaryPhone"]);
tenantDetBO.AlternatePhone = reader["AlternatePhone"] == DBNull.Value ? string.Empty : Convert.ToString(reader["AlternatePhone"]);
tenantDetBO.Fax = reader["Fax"] == DBNull.Value ? string.Empty : Convert.ToString(reader["Fax"]);
tenantDetBO.Email = reader["Email"] == DBNull.Value ? string.Empty : Convert.ToString(reader["Email"]);
tenantDetBO.Logo = reader["Logo"] == DBNull.Value ? string.Empty : Convert.ToString(reader["Logo"]);
tenantDetBO.SmallLogo = reader["SmallLogo"] == DBNull.Value ? string.Empty : Convert.ToString(reader["SmallLogo"]);
tenantDetBO.DomainPrefix = reader["DomainPrefix"] == DBNull.Value ? string.Empty : Convert.ToString(reader["DomainPrefix"]);
tenantDetBO.TenantAdminID = reader["TenantAdminID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["TenantAdminID"]);
tenantDetBO.TenantStatus = reader["TenantStatus"] == DBNull.Value ? string.Empty : Convert.ToString(reader["TenantStatus"]);
tenantDetBO.ProfileCreatedOn = reader["ProfileCreatedOn"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(reader["ProfileCreatedOn"]);
tenantDetBO.CreatedFromIP = reader["CreatedFromIP"] == DBNull.Value ? string.Empty : Convert.ToString(reader["CreatedFromIP"]);
tenantDetBO.GeoRegion = reader["GeoRegion"] == DBNull.Value ? string.Empty : Convert.ToString(reader["GeoRegion"]);
tenantDetBO.BillAddress1 = reader["BillAddress1"] == DBNull.Value ? string.Empty : Convert.ToString(reader["BillAddress1"]);
tenantDetBO.BillAddress2 = reader["BillAddress2"] == DBNull.Value ? string.Empty : Convert.ToString(reader["BillAddress2"]);
tenantDetBO.BillCity = reader["BillCity"] == DBNull.Value ? string.Empty : Convert.ToString(reader["BillCity"]);
tenantDetBO.BillZipCode = reader["BillZipCode"] == DBNull.Value ? string.Empty : Convert.ToString(reader["BillZipCode"]);
tenantDetBO.BillState = reader["BillState"] == DBNull.Value ? string.Empty : Convert.ToString(reader["BillState"]);
tenantDetBO.BillCountry = reader["BillCountry"] == DBNull.Value ? string.Empty : Convert.ToString(reader["BillCountry"]);
tenantDetBO.IsProfileComplete = reader["IsProfileComplete"] == DBNull.Value ? false : Convert.ToBoolean(reader["IsProfileComplete"]);
tenantDetBO.ContactUsTelephone = reader["ContactUsTelephone"] == DBNull.Value ? string.Empty : Convert.ToString(reader["ContactUsTelephone"]);
tenantDetBO.ContactUsEmailID = reader["ContactUsEmailID"] == DBNull.Value ? string.Empty : Convert.ToString(reader["ContactUsEmailID"]);
}
}
reader.Close();
connection.Close();
}
}
return(tenantDetBO);
}
public HttpResponseMessage Post([FromBody] KitOrder kitOrder /*string LastName, string PersionType, string OrgName, string Address, string City, string State, string Country, string Zip, string Telephone, string Email, string Message, string AuthenticateToken*/)
{
ApiDA apiDA = new ApiDA();
HttpResponseMessage responce = new HttpResponseMessage();
// bool isEntity=apiDA.CheckEntity(kitOrder.AuthenticateToken);
int TenantID = apiDA.CheckEntity(kitOrder.AuthenticateToken);
if (TenantID > 0)
{
CustomerBO cutomerBo = new CustomerBO
{
FirstName = kitOrder.FirstName.Trim(),
LastName = kitOrder.LastName.Trim(),
TenantID = TenantID,
Address1 = kitOrder.Address.Trim(),
City = kitOrder.City.Trim(),
State = kitOrder.State.Trim(),
Zipcode = kitOrder.Zip.Trim(),
Email = kitOrder.Email.Trim(),
Message = kitOrder.Message.Trim(),
RequesterType = kitOrder.RequesterType.Trim(),
Facility = kitOrder.OrgName.Trim(),
Country = kitOrder.Country.Trim(),
Phone = kitOrder.Telephone.Trim(),
CustID = 0,
};
//if (btnSubmit.OnClientClick ="true")
//{
// lblSubmit.Text = "SuccessMessage";
//}
//string message = "Your details have been saved successfully.";
//string script = "window.onload = function(){ alert('";
//script += message;
//script += "')};";
//ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true);
ApiDA customerDA = new ApiDA();
int customerNo = customerDA.SaveCustomerNumber(cutomerBo);
//Save and Edit request Details
if (customerNo > 0)
{
OrderRequestBO ordreqBO = new ApiDA().SaveOrderRequest(new OrderRequestBO
{
RequestID = Convert.ToInt32(0),
TenantID = TenantID,
NoOfKits = Convert.ToInt32(kitOrder.NoOfKits),
KitType = "Frat",
CustomerNumber = customerNo.ToString(),
});
try
{
OrderKitBO okBO = new OrderKitBO();
TenantDetailsBO tenantDetailBO = new TenantDetailsBO();
tenantDetailBO = new ApiDA().getTenantDetails(TenantID);
string ordNumber = ordreqBO.RequestNumber;
List <EmailEnablementImplementationBO> emailBO = new ApiDA().emailEnableImplementation(TenantID, 1);
if (emailBO[0].emailEnablementBO.isToTenant == true)
{
emailBO[0].emailEnablementTypeBO.TenantTemplate = emailBO[0].emailEnablementTypeBO.TenantTemplate.Replace("@TenantName", tenantDetailBO.TenantName);
emailBO[0].emailEnablementTypeBO.TenantTemplate = emailBO[0].emailEnablementTypeBO.TenantTemplate.Replace("@End-userName", (kitOrder.FirstName.Trim() + " " + kitOrder.LastName.Trim()));
emailBO[0].emailEnablementTypeBO.TenantTemplate = emailBO[0].emailEnablementTypeBO.TenantTemplate.Replace("@Date:Time", DateTime.Now.ToShortDateString());
emailBO[0].emailEnablementTypeBO.TenantTemplate = emailBO[0].emailEnablementTypeBO.TenantTemplate.Replace("@RequestID", ordNumber);
EmailConfigBO ema = new EmailConfigBO();
ema.Body = emailBO[0].emailEnablementTypeBO.TenantTemplate;
ema.Subject = "Order Confirmation";
ema.ToAddress = emailBO[0].emailEnablementBO.ToTenantEmails;
SendEmail(ema);
}
if (emailBO[0].emailEnablementBO.isToEndUser == true)
{
emailBO[0].emailEnablementTypeBO.EndUserTemplate = emailBO[0].emailEnablementTypeBO.EndUserTemplate.Replace("@End-userName", (kitOrder.FirstName.Trim() + " " + kitOrder.LastName.Trim()));
emailBO[0].emailEnablementTypeBO.EndUserTemplate = emailBO[0].emailEnablementTypeBO.EndUserTemplate.Replace("@RequestID", ordNumber);
emailBO[0].emailEnablementTypeBO.EndUserTemplate = emailBO[0].emailEnablementTypeBO.EndUserTemplate.Replace("@Date:Time", DateTime.Now.ToShortDateString());
emailBO[0].emailEnablementTypeBO.EndUserTemplate = emailBO[0].emailEnablementTypeBO.EndUserTemplate.Replace("@DeliveryDuration", "5-10 days");
emailBO[0].emailEnablementTypeBO.EndUserTemplate = emailBO[0].emailEnablementTypeBO.EndUserTemplate.Replace("@Telephone", tenantDetailBO.ContactUsTelephone);
emailBO[0].emailEnablementTypeBO.EndUserTemplate = emailBO[0].emailEnablementTypeBO.EndUserTemplate.Replace("@ContactusEmailID", tenantDetailBO.ContactUsEmailID);
EmailConfigBO ema = new EmailConfigBO();
ema.Body = emailBO[0].emailEnablementTypeBO.EndUserTemplate;
ema.Subject = "Order Confirmation";
ema.ToAddress = kitOrder.Email.Trim();
SendEmail(ema);
}
responce = Request.CreateResponse(HttpStatusCode.OK, "");
}
catch (Exception exp)
{
// btnSubmit.Text = "TargetSite :" + exp.TargetSite + "Message :" + exp.Message;
}
}
else
{
HttpError error = new HttpError("Oops!");
responce = Request.CreateErrorResponse(HttpStatusCode.InternalServerError, error);
}
//int id= apiDA.SaveOrderKitData(kitOrder);
//if (id > 0)
//{
// responce= Request.CreateResponse(HttpStatusCode.OK,"");
//}
//else
//{
//}
}
else
{
HttpError error = new HttpError("User is not Authenticated");
responce = Request.CreateErrorResponse(HttpStatusCode.Unauthorized, error);
}
return(responce);
}