public BaseApiResponse InsertNewLocation(OrderWizardStep6 model)
{
var response = new BaseApiResponse();
try
{
SqlParameter[] param = { new SqlParameter("LocID", (object)model.LocID ?? (object)DBNull.Value)
, new SqlParameter("Name1", (object)model.Name1 ?? (object)DBNull.Value)
, new SqlParameter("Name2", (object)model.Name2 ?? (object)DBNull.Value)
, new SqlParameter("Dept", (object)model.Dept ?? (object)DBNull.Value)
, new SqlParameter("Street1", (object)model.Street1 ?? (object)DBNull.Value)
, new SqlParameter("Street2", (object)model.Street2 ?? (object)DBNull.Value)
, new SqlParameter("City", (object)model.City ?? (object)DBNull.Value)
, new SqlParameter("State", (object)model.State ?? (object)DBNull.Value)
, new SqlParameter("Zip", (object)model.Zip ?? (object)DBNull.Value)
, new SqlParameter("AreaCode1", (object)model.AreaCode1 ?? (object)DBNull.Value)
, new SqlParameter("PhoneNo1", (object)model.PhoneNo1 ?? (object)DBNull.Value)
, new SqlParameter("AreaCode2", (object)model.AreaCode2 ?? (object)DBNull.Value)
, new SqlParameter("PhoneNo2", (object)model.PhoneNo2 ?? (object)DBNull.Value)
, new SqlParameter("AreaCode3", (object)model.AreaCode3 ?? (object)DBNull.Value)
, new SqlParameter("FaxNo", (object)model.FaxNo ?? (object)DBNull.Value)
, new SqlParameter("Comment", (object)model.Comment ?? (object)DBNull.Value)
, new SqlParameter("CreatedBy", (object)model.EmpId ?? (object)DBNull.Value) };
var resultlocation = _repository.ExecuteSQL <string>("InsertOrUpdateNewLocationStep6", param).FirstOrDefault();
if (resultlocation != "")
{
response.Success = true;
response.str_ResponseData = resultlocation;
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public async Task <BaseApiResponse> SubmitOrder(OrderWizardStep1 model)
{
var response = new BaseApiResponse();
// IF NO LOCATION IS INSERTED DURING NEW ORDER THEN ASSIGN DEFAULT LOCATION
int partCount = 0;
SqlParameter[] paramPartCount = { new SqlParameter("OrderNo", (object)model.OrderId ?? (object)DBNull.Value) };
partCount = _repository.ExecuteSQL <int>("CountTotalPartByOrderNo", paramPartCount).FirstOrDefault();
if (partCount == 0)
{
int recordType = 4; // Billing Records
try
{
string defaultLocation = GetDefaultLocationByCompanyNo(model.CompanyNo);
OrderWizardStep3 resultStep3 = new OrderWizardStep3();
SqlParameter[] paramStep3 = { new SqlParameter("OrderId", (object)model.OrderId ?? (object)DBNull.Value) };
resultStep3 = _repository.ExecuteSQL <OrderWizardStep3>("GetOrderWizardStep3Details", paramStep3).FirstOrDefault();
SqlParameter[] paramScope = { new SqlParameter("OrderNo", (object)model.OrderId ?? (object)DBNull.Value)
, new SqlParameter("RecType", (object)recordType ?? (object)DBNull.Value) };
string resultScope = _repository.ExecuteSQL <string>("GetScopeForLocation", paramScope).FirstOrDefault();
OrderWizardStep6 defaultPart = new OrderWizardStep6();
defaultPart.OrderId = Convert.ToInt64(model.OrderId);
defaultPart.LocID = defaultLocation;
defaultPart.EmpId = model.EmpId;
defaultPart.IsAuthorization = true;
defaultPart.RecordTypeId = recordType;
defaultPart.RequestMeansId = 1;
defaultPart.ScopeStartDate = resultStep3.DateOfBirth;
defaultPart.ScopeEndDate = DateTime.Now.Date;
defaultPart.Scope = resultScope;
OrderWizardStep6ApiController step6 = new OrderWizardStep6ApiController();
await step6.InsertOrUpdateOrderWizardStep6(defaultPart);
}
catch (Exception ex)
{
}
}
try
{
if (model.OrderId > 0)
{
SqlParameter[] Sqlparam = { new SqlParameter("OrderId", (object)model.OrderId ?? (object)DBNull.Value) };
var orderResult = _repository.ExecuteSQL <OrderWizardStep1>("GetOrderWizardStep1Details", Sqlparam).ToList();
if (orderResult != null && orderResult.Count > 0)
{
model.SubmitStatus = orderResult[0].SubmitStatus;
}
int result = 0;
try
{
SqlParameter[] param = { new SqlParameter("OrderId", (object)model.OrderId ?? (object)DBNull.Value)
, new SqlParameter("UpdatedBy", (object)model.EmpId ?? (object)DBNull.Value)
, new SqlParameter("UserAccessId", (object)model.UserAccessId ?? (object)DBNull.Value) };
result = _repository.ExecuteSQL <int>("SubmitOrder", param).FirstOrDefault();
}
catch (Exception ex)
{
}
if (result > 0)
{
//Upload Location Documents on Final Submit
SqlParameter[] SqlFileparam = { new SqlParameter("OrderNo", (object)model.OrderId ?? (object)DBNull.Value),
new SqlParameter("PartNo", (object)0 ?? (object)DBNull.Value) };
var LocDocumentList = _repository.ExecuteSQL <LocationFilesModel>("GetLocationTempFilesForNewOrder", SqlFileparam).ToList();
if (LocDocumentList != null && LocDocumentList.Count > 0)
{
string sourcePath = ConfigurationManager.AppSettings["AttachPathLocal"].ToString();
string destinationPath = ConfigurationManager.AppSettings["UploadRoot"].ToString();
foreach (var item in LocDocumentList)
{
SqlParameter[] deleteattachparam =
{
new SqlParameter("OrderNo", (object)model.OrderId ?? (object)DBNull.Value),
new SqlParameter("PartNo", (object)item.PartNo ?? (object)DBNull.Value),
new SqlParameter("FileTypeId", (object)item.FileTypeId ?? (object)DBNull.Value),
new SqlParameter("DeleteFromLocFile", (object)(int)0 ?? (object)DBNull.Value),
new SqlParameter("LocFileId", (object)(int)0 ?? (object)DBNull.Value)
};
_repository.ExecuteSQL <int>("DeleteLocationFile", deleteattachparam).FirstOrDefault();
}
foreach (var docitem in LocDocumentList)
{
var destPath = destinationPath + "/" + docitem.OrderNo + "/" + docitem.PartNo;
string fileDiskName = new Document().MoveLocalToServerFile(docitem.FileName, docitem.BatchId, sourcePath, destPath, docitem.OrderNo, docitem.PartNo.ToString());
docitem.OrderNo = Convert.ToInt32(docitem.OrderNo);
docitem.FileDiskName = fileDiskName;
docitem.Pages = 0;
string xmlAttachData = ConvertToXml <LocationFilesModel> .GetXMLString(new List <LocationFilesModel>() { docitem });
SqlParameter[] attachparam = { new SqlParameter("xmlDataString", (object)xmlAttachData ?? (object)DBNull.Value) };
_repository.ExecuteSQL <int>("InsertFiles", attachparam).FirstOrDefault();
}
foreach (var docitem in LocDocumentList)
{
Document docobj = new Document();
docobj.DeleteAttchFile(docitem.FileName, docitem.BatchId, sourcePath);
}
SqlParameter[] deleteLocationFile =
{
new SqlParameter("OrderNo", (object)model.OrderId ?? (object)DBNull.Value)
};
_repository.ExecuteSQL <int>("DeleteLocationFileByOrderNo", deleteLocationFile).FirstOrDefault();
}
await new OrderProcess().OrderSummaryEmail(Convert.ToInt32(model.OrderId), model.UserEmail, model.CompanyNo, Convert.ToInt32(model.SubmitStatus));
await new OrderProcess().AddQuickformsForNewOrder(Convert.ToInt32(model.OrderId), Convert.ToBoolean(model.SubmitStatus), Convert.ToBoolean(model.SubmitStatus), logoDirectoryPath: HttpContext.Current.Server.MapPath(@"~/assets/images/"));
// await new OrderProcess().ESignature(Convert.ToInt32(model.OrderId), model.CompanyNo);
InsertWaiverForNewOrder(Convert.ToInt32(model.OrderId));
// UPDATE isAddedPart TO 0 OF ALL PART AFTER PROCESSING ORDER
SqlParameter[] paramAddedPart = { new SqlParameter("OrderNo", (object)model.OrderId ?? (object)DBNull.Value) };
int resultAddedPart = _repository.ExecuteSQL <int>("SubmitOrderUpdateisAddedPart", paramAddedPart).FirstOrDefault();
response.Success = true;
}
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public async System.Threading.Tasks.Task <BaseApiResponse> InsertOrUpdateOrderWizardStep6(OrderWizardStep6 model)
{
// $scope.IsAuthorizationAry = [{ Id: true, Name: 'Authorization' }, { Id: false, Name: 'Subpoena Only' }];
// $scope.RequestMeansAry = [{ Id: 1, Name: 'Create' }, { Id: 2, Name: 'Upload' }, { Id: 3, Name: 'Upload Batch' }];
//if (model.RequestMeansId == 3) //BATCH UPLOAD
//{
// model.AsgnTo = "ORDENE";
// model.Note = "Input Order : Files upload via batch.";
//}
//else
//{
// if (model.IsAuthorization == false) // CREATE OR UPLOAD SUBPOENA // if(isCreateAuthSubp = 0)
// {
// if(isSubpoena==1)
// model.AsgnTo = "ORDENE";
// model.Note = "Subpoena.";
// }
// else if (model.IsAuthorization == true)
// {
// if (model.RequestMeansId == 1) // CREATE AUTHORIZATION
// { if(iscrateauthsub == 1,isAuth==1)
// model.AsgnTo = "AUTHSS";
// model.Note = "Input Order : Authorization sent to Palntiff for signature.";
// }
// if (model.RequestMeansId == 2) // UPLOAD AUTHORIZATION
// {if(iscrateauthsub == 0,isAuth==1)
// model.AsgnTo = "REQUES";
// model.Note = "Input Order : Send request to location.";
// }
// }
//}
model.PartNo = model.PartNo == null ? 0 : model.PartNo;
int IsAdmin = model.RoleName == "Administrator" ? 1 : 0;
var response = new BaseApiResponse();
try
{
string linklocation = string.Empty;// model.LocID + "|" + model.RecordTypeId;
if (model.PartNo == 0)
{
SqlParameter[] linkparam = { new SqlParameter("LocId", (object)model.LocID ?? (object)DBNull.Value)
, new SqlParameter("RecordTypeId", (object)model.RecordTypeId ?? (object)DBNull.Value)
, new SqlParameter("OrderNo", (object)model.OrderId ?? (object)DBNull.Value) };
var locationresult = _repository.ExecuteSQL <string>("GetLinkLocation", linkparam).FirstOrDefault();
linklocation = linklocation + ',' + Convert.ToString(locationresult);
string[] splitlocation = linklocation.Trim(',').Split(',');
int cnt = 0;
string addedPart = string.Empty;
foreach (string loc in splitlocation)
{
cnt++;
string scope = model.Scope;
if (cnt > 1)
{
SqlParameter[] paramscope = { new SqlParameter("OrderNo", (object)model.OrderId ?? (object)DBNull.Value)
, new SqlParameter("RecType", (object)loc.Split('|')[1] ?? (object)DBNull.Value) };
var resultscope = _repository.ExecuteSQL <string>("GetScopeForLocation", paramscope).ToList();
if (resultscope != null)
{
scope = Convert.ToString(resultscope[0]);
}
else
{
scope = "";
}
}
SqlParameter[] param1 = { new SqlParameter("LocId", (object)loc.Split('|')[0] ?? (object)DBNull.Value)
, new SqlParameter("OrderLocationId", (object)model.OrderLocationId ?? (object)DBNull.Value)
, new SqlParameter("OrderId", (object)model.OrderId ?? (object)DBNull.Value)
, new SqlParameter("IsAuthorization", (object)model.IsAuthorization ?? (object)DBNull.Value)
, new SqlParameter("RequestMeansId", (object)model.RequestMeansId ?? (object)DBNull.Value)
, new SqlParameter("IsRequireAdditionalService", (object)model.IsRequireAdditionalService ?? (object)DBNull.Value)
, new SqlParameter("ScopeStartDate", (object)model.ScopeStartDate ?? (object)DBNull.Value)
, new SqlParameter("ScopeEndDate", (object)model.ScopeEndDate ?? (object)DBNull.Value)
, new SqlParameter("Comment", (object)model.Comment ?? (object)DBNull.Value)
, new SqlParameter("IsOtherChecked", (object)model.IsOtherChecked ?? (object)DBNull.Value)
, new SqlParameter("RecordTypeId", (object)loc.Split('|')[1] ?? (object)DBNull.Value)
, new SqlParameter("CreatedBy", (object)model.EmpId ?? (object)DBNull.Value)
, new SqlParameter("UserAccessId", (object)model.UserAccessId ?? (object)DBNull.Value)
, new SqlParameter("EmpId", (object)model.EmpId ?? (object)DBNull.Value)
, new SqlParameter("AsgnTo", (object)model.AsgnTo ?? (object)DBNull.Value)
, new SqlParameter("Note", (object)model.Note ?? (object)DBNull.Value)
, new SqlParameter("Scope", (object)scope ?? (object)DBNull.Value)
, new SqlParameter("IsAdmin", (object)IsAdmin ?? (object)DBNull.Value)
, new SqlParameter("Partno", (object)model.PartNo ?? (object)DBNull.Value
) };
var result = _repository.ExecuteSQL <int>("InsertOrUpdateOrderWizardStep6", param1).FirstOrDefault();
addedPart += result + ",";
if (result > 0)
{
if (model.DocumentFileList != null && model.DocumentFileList.Count > 0)
{
foreach (var docitem in model.DocumentFileList)
{
SqlParameter[] attachparam = { new SqlParameter("OrderNo", (object)model.OrderId ?? (object)DBNull.Value),
new SqlParameter("PartNo", (object)result ?? (object)DBNull.Value),
new SqlParameter("FileName", (object)docitem.FileName ?? (object)DBNull.Value),
new SqlParameter("BatchId", (object)docitem.BatchId ?? (object)DBNull.Value),
new SqlParameter("LocID", (object)loc.Split('|')[0] ?? (object)DBNull.Value),
new SqlParameter("FileTypeId", (object)(docitem.IsAuthSub == true?(int)FileType.Authorization:(int)FileType.Request) ?? (object)DBNull.Value),
new SqlParameter("RecordTypeId", (object)loc.Split('|')[1] ?? (object)DBNull.Value),
new SqlParameter("CreatedBy", (object)model.CreatedBy ?? (object)DBNull.Value) };
_repository.ExecuteSQL <int>("InsertLocationFiles", attachparam).FirstOrDefault();
}
}
response.Success = true;
response.lng_InsertedId = result;
}
}
}
else
{
SqlParameter[] param1 = { new SqlParameter("LocId", (object)model.LocID ?? (object)DBNull.Value)
, new SqlParameter("OrderLocationId", (object)model.OrderLocationId ?? (object)DBNull.Value)
, new SqlParameter("OrderId", (object)model.OrderId ?? (object)DBNull.Value)
, new SqlParameter("IsAuthorization", (object)model.IsAuthorization ?? (object)DBNull.Value)
, new SqlParameter("RequestMeansId", (object)model.RequestMeansId ?? (object)DBNull.Value)
, new SqlParameter("IsRequireAdditionalService", (object)model.IsRequireAdditionalService ?? (object)DBNull.Value)
, new SqlParameter("ScopeStartDate", (object)model.ScopeStartDate ?? (object)DBNull.Value)
, new SqlParameter("ScopeEndDate", (object)model.ScopeEndDate ?? (object)DBNull.Value)
, new SqlParameter("Comment", (object)model.Comment ?? (object)DBNull.Value)
, new SqlParameter("IsOtherChecked", (object)model.IsOtherChecked ?? (object)DBNull.Value)
, new SqlParameter("RecordTypeId", (object)model.RecordTypeId ?? (object)DBNull.Value)
, new SqlParameter("CreatedBy", (object)model.EmpId ?? (object)DBNull.Value)
, new SqlParameter("UserAccessId", (object)model.UserAccessId ?? (object)DBNull.Value)
, new SqlParameter("EmpId", (object)model.EmpId ?? (object)DBNull.Value)
, new SqlParameter("AsgnTo", (object)model.AsgnTo ?? (object)DBNull.Value)
, new SqlParameter("Note", (object)model.Note ?? (object)DBNull.Value)
, new SqlParameter("Scope", (object)model.Scope ?? (object)DBNull.Value)
, new SqlParameter("IsAdmin", (object)IsAdmin ?? (object)DBNull.Value)
, new SqlParameter("Partno", (object)model.PartNo ?? (object)DBNull.Value
) };
var result = _repository.ExecuteSQL <int>("InsertOrUpdateOrderWizardStep6", param1).FirstOrDefault();
if (model.DocumentFileList != null && model.DocumentFileList.Count > 0)
{
foreach (var docitem in model.DocumentFileList)
{
SqlParameter[] attachparam = { new SqlParameter("OrderNo", (object)model.OrderId ?? (object)DBNull.Value),
new SqlParameter("PartNo", (object)result ?? (object)DBNull.Value),
new SqlParameter("FileName", (object)docitem.FileName ?? (object)DBNull.Value),
new SqlParameter("BatchId", (object)docitem.BatchId ?? (object)DBNull.Value),
new SqlParameter("LocID", (object)model.OrderId ?? (object)DBNull.Value),
new SqlParameter("FileTypeId", (object)(docitem.IsAuthSub == true?(int)FileType.Authorization:(int)FileType.Request) ?? (object)DBNull.Value),
new SqlParameter("RecordTypeId", (object)model.RecordTypeId ?? (object)DBNull.Value),
new SqlParameter("CreatedBy", (object)model.CreatedBy ?? (object)DBNull.Value) };
_repository.ExecuteSQL <int>("InsertLocationFiles", attachparam).FirstOrDefault();
}
}
response.Success = true;
response.lng_InsertedId = result;
}
SqlParameter[] paramStatus = { new SqlParameter("OrderNo", (object)model.OrderId ?? (object)DBNull.Value) };
bool isPartAddLater = _repository.ExecuteSQL <bool>("GetOrderStatus", paramStatus).FirstOrDefault();
// HERE RIGHT CODE FOR SUBMIT
// GetOrderStatus
if (isPartAddLater)
{
//SqlParameter[] param = {new SqlParameter("OrderId", (object)model.OrderId ?? (object)DBNull.Value)
// ,new SqlParameter("UpdatedBy", (object)model.EmpId ?? (object)DBNull.Value)
// ,new SqlParameter("UserAccessId", (object)model.UserAccessId ?? (object)DBNull.Value)};
//var result = _repository.ExecuteSQL<int>("SubmitOrderAddedPart", param).FirstOrDefault();
//await new OrderProcess().AddQuickformsForNewOrder(Convert.ToInt32(model.OrderId), false, true, addedPart.Trim(','));
//await new OrderProcess().OrderSummaryEmail(Convert.ToInt32(model.OrderId), model.LoggedInUserEmail , Convert.ToInt32(isPartAddLater));
//await new OrderProcess().ESignature(Convert.ToInt32(model.OrderId));
}
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
