//Update
public DC_Message UpdateSupplierStaticFileDetails(MDMSVC.DC_SupplierImportFileDetails RQ)
{
object result = null;
ServiceConnection.MDMSvcProxy.PostData(ConfigurationManager.AppSettings["SupplierFileDetails_Update"], RQ, typeof(MDMSVC.DC_SupplierImportFileDetails), typeof(DC_Message), out result);
return(result as DC_Message);
}
protected void gvFileUploadSearchForNew_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
GridViewRow row = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
int index = row.RowIndex;
Guid myRowId = Guid.Parse(gvFileUploadSearchForNew.DataKeys[index].Values[0].ToString());
if (e.CommandName == "SoftDelete")
{
MDMSVC.DC_SupplierImportFileDetails_RQ RQ = new MDMSVC.DC_SupplierImportFileDetails_RQ();
RQ.SupplierImportFile_Id = myRowId;
RQ.PageNo = 0;
RQ.PageSize = int.MaxValue;
var res = _objMappingSVCs.GetSupplierStaticFileDetails(RQ);
MDMSVC.DC_SupplierImportFileDetails obj = new MDMSVC.DC_SupplierImportFileDetails
{
SupplierImportFile_Id = myRowId,
STATUS = res[0].STATUS,
PROCESS_DATE = DateTime.Now,
PROCESS_USER = System.Web.HttpContext.Current.User.Identity.Name,
IsActive = false
};
var result = _objMappingSVCs.UpdateSupplierStaticFileDetails(obj);
fillmatchingdataForNew(10, 0);
BootstrapAlert.BootstrapAlertMessage(dvMsg, "File has been deleted Successfully", (BootstrapAlertType)result.StatusCode);
}
if (e.CommandName == "UnDelete")
{
MDMSVC.DC_SupplierImportFileDetails_RQ RQ = new MDMSVC.DC_SupplierImportFileDetails_RQ();
RQ.SupplierImportFile_Id = myRowId;
RQ.PageNo = 0;
RQ.PageSize = int.MaxValue;
var res = _objMappingSVCs.GetSupplierStaticFileDetails(RQ);
MDMSVC.DC_SupplierImportFileDetails obj = new MDMSVC.DC_SupplierImportFileDetails
{
SupplierImportFile_Id = myRowId,
STATUS = res[0].STATUS,
PROCESS_DATE = DateTime.Now,
PROCESS_USER = System.Web.HttpContext.Current.User.Identity.Name,
IsActive = true
};
var result = _objMappingSVCs.UpdateSupplierStaticFileDetails(obj);
fillmatchingdataForNew(10, 0);
BootstrapAlert.BootstrapAlertMessage(dvMsg, "File has been un deleted Successfully", (BootstrapAlertType)result.StatusCode);
}
}
catch
{
}
}
public MDMSVC.DC_Message InsertFileRecord(string Entity, ReRunMode Mode)
{
Guid SupplierImportFile_Id = Guid.NewGuid();
MappingSVCs _objMappingSVCs = new MappingSVCs();
MDMSVC.DC_SupplierImportFileDetails _objFileDetails = new MDMSVC.DC_SupplierImportFileDetails();
_objFileDetails.SupplierImportFile_Id = SupplierImportFile_Id;
_objFileDetails.Supplier_Id = Guid.Parse(ddlSupplierName.SelectedValue);
_objFileDetails.Entity = Entity;
_objFileDetails.OriginalFilePath = "";
_objFileDetails.SavedFilePath = "";
if (Mode == ReRunMode.RERUN)
{
_objFileDetails.STATUS = "UPLOADED";
}
else if (Mode == ReRunMode.SCHEDULE)
{
_objFileDetails.STATUS = "SCHEDULED";
}
_objFileDetails.Mode = "RE_RUN";
_objFileDetails.CREATE_DATE = DateTime.Now;
_objFileDetails.CREATE_USER = System.Web.HttpContext.Current.User.Identity.Name;
MDMSVC.DC_Message _objMsg = _objMappingSVCs.SaveSupplierStaticFileDetails(_objFileDetails);
if (Mode == ReRunMode.RERUN)
{
//file Process logic
MDMSVC.DC_SupplierImportFileDetails obj = new MDMSVC.DC_SupplierImportFileDetails();
MDMSVC.DC_SupplierImportFileDetails_RQ RQ = new MDMSVC.DC_SupplierImportFileDetails_RQ();
RQ.SupplierImportFile_Id = SupplierImportFile_Id;
RQ.PageNo = 0;
RQ.PageSize = int.MaxValue;
var res = _objMappingSVCs.GetSupplierStaticFileDetails(RQ);
obj.SupplierImportFile_Id = res[0].SupplierImportFile_Id;
obj.Supplier_Id = res[0].Supplier_Id;
obj.Supplier = res[0].Supplier;
obj.SavedFilePath = res[0].SavedFilePath;
obj.PROCESS_USER = System.Web.HttpContext.Current.User.Identity.Name;
obj.Entity = res[0].Entity;
obj.STATUS = res[0].STATUS;
obj.Mode = res[0].Mode;
var result = _objMappingSVCs.StaticFileUploadProcessFile(obj);
//end
//view File details
hdnFileId.Value = SupplierImportFile_Id.ToString();
ClientScript.RegisterStartupScript(this.GetType(), "showDetailsModal", "showDetailsModal('" + SupplierImportFile_Id + "');", true);
}
// Response.Redirect("~/staticdata/files/upload.aspx");
return(_objMsg);
}
protected void btnUploadComplete_Click(object sender, EventArgs e)
{
if (ddlSupplierList.SelectedValue == "0" || ddlEntityList.SelectedValue == "0")
{
BootstrapAlert.BootstrapAlertMessage(dvmsgUploadCompleted, "Please select valid supplier & entity before upload.", BootstrapAlertType.Danger);
return;
}
MDMSVC.DC_SupplierImportFileDetails_RQ RQParam = new MDMSVC.DC_SupplierImportFileDetails_RQ();
if (ddlSupplierList.SelectedItem.Value != "0")
{
RQParam.Supplier_Id = Guid.Parse(ddlSupplierList.SelectedItem.Value);
}
if (ddlEntityList.SelectedItem.Value != "0")
{
RQParam.Entity = ddlEntityList.SelectedItem.Text;
}
var res = _objMappingSVCs.GetSupplierStaticFileDetails(RQParam);
if (res != null)
{
if (res.Count > 0)
{
MDMSVC.DC_SupplierImportFileDetails RQParams = new MDMSVC.DC_SupplierImportFileDetails();
RQParams.Supplier_Id = Guid.Parse(ddlSupplierList.SelectedItem.Value);
RQParams.Entity = ddlEntityList.SelectedItem.Text;
RQParams.STATUS = "NEW";
RQParams.IsActive = true;
gvFileUploadSearchForNew.VirtualItemCount = res[0].TotalRecords;
//lblTotalRecords.Text = res[0].TotalRecords.ToString();
_objMappingSVCs.UpdateSupplierImportFileDetailsFromNewToUploaded(RQParams);
fillmatchingdataForNew(10, 0);
//clearControls();
//BindDropdown();
}
else
{
BootstrapAlert.BootstrapAlertMessage(dvmsgUploadCompleted, "No file has been selected to upload.", BootstrapAlertType.Danger);
}
}
else
{
BootstrapAlert.BootstrapAlertMessage(dvmsgUploadCompleted, "No file has been selected to upload.", BootstrapAlertType.Danger);
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
if (ddlSupplierList.SelectedValue == "0" || ddlEntityList.SelectedValue == "0")
{
BootstrapAlert.BootstrapAlertMessage(dvmsgUploadCompleted, "Please select valid supplier & entity before upload.", BootstrapAlertType.Danger);
return;
}
if (FileUpload1.HasFile)
{
string strFileType = System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName).Replace(".", "").ToLower();
string strSavedValidFileExtension = ValidFile();
if (strFileType == string.Empty)
{
BootstrapAlert.BootstrapAlertMessage(dvmsgUploadCompleted, "Invalid file.", BootstrapAlertType.Danger);
}
else if (strSavedValidFileExtension == string.Empty)
{
BootstrapAlert.BootstrapAlertMessage(dvmsgUploadCompleted, "No file type has been defined.", BootstrapAlertType.Danger);
}
else if (strSavedValidFileExtension == strFileType)
{
Guid FileUploadId = Guid.NewGuid();
long ActualFileSize = FileUpload1.PostedFile.ContentLength;
var response = UploadFileInChunks(FileUpload1.PostedFile, ActualFileSize, FileUploadId);
if (response.UploadSucceeded)
{
MappingSVCs _objMappingSVCs = new MappingSVCs();
MDMSVC.DC_SupplierImportFileDetails _objFileDetails = new MDMSVC.DC_SupplierImportFileDetails();
_objFileDetails.SupplierImportFile_Id = FileUploadId;
_objFileDetails.Supplier_Id = Guid.Parse(ddlSupplierList.SelectedValue);
_objFileDetails.Entity = ddlEntityList.SelectedItem.Text;
_objFileDetails.OriginalFilePath = FileUpload1.FileName;
_objFileDetails.SavedFilePath = response.UploadedPath;
//_objFileDetails.STATUS = "UPLOADED";
_objFileDetails.STATUS = "NEW";
_objFileDetails.Mode = "ALL";
_objFileDetails.CREATE_DATE = DateTime.Now;
_objFileDetails.CREATE_USER = System.Web.HttpContext.Current.User.Identity.Name;
MDMSVC.DC_Message _objMsg = _objMappingSVCs.SaveSupplierStaticFileDetails(_objFileDetails);
if (_objMsg.StatusCode == MDMSVC.ReadOnlyMessageStatusCode.Success)
{
btnReset_Click(null, EventArgs.Empty);
BootstrapAlert.BootstrapAlertMessage(dvmsgUploadCompleted, _objMsg.StatusMessage, BootstrapAlertType.Success);
}
else
{
BootstrapAlert.BootstrapAlertMessage(dvmsgUploadCompleted, _objMsg.StatusMessage, BootstrapAlertType.Danger);
}
_objFileDetails = null;
clearControls();
}
}
else
{
BootstrapAlert.BootstrapAlertMessage(dvmsgUploadCompleted, "Please select valid file.", BootstrapAlertType.Danger);
}
}
else
{
BootstrapAlert.BootstrapAlertMessage(dvmsgUploadCompleted, "No file has been selected to upload.", BootstrapAlertType.Danger);
}
}
protected void gvFileUploadSearch_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
GridViewRow row = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
int index = row.RowIndex;
Guid myRowId = Guid.Parse(gvFileUploadSearch.DataKeys[index].Values[0].ToString());
if (e.CommandName.ToString() == "ViewDetails")
{
List <MDMSVC.DC_SupplierImportFileDetails> lstobj = new List <MDMSVC.DC_SupplierImportFileDetails>();
MDMSVC.DC_SupplierImportFileDetails obj = new MDMSVC.DC_SupplierImportFileDetails();
MDMSVC.DC_SupplierImportFileDetails_RQ RQ = new MDMSVC.DC_SupplierImportFileDetails_RQ();
SelectedSupplierImportAttributeValue_Id = myRowId;
SupplierImportFile_Id = myRowId;
RQ.SupplierImportFile_Id = myRowId;
RQ.PageNo = 0;
RQ.PageSize = int.MaxValue;
var res = _objMappingSVCs.GetSupplierStaticFileDetails(RQ);
if (res != null && res.Count > 0)
{
hdnViewDetailsFlag.Value = "false";
}
}
if (e.CommandName.ToString() == "Process")
{
MDMSVC.DC_SupplierImportFileDetails obj = new MDMSVC.DC_SupplierImportFileDetails();
MDMSVC.DC_SupplierImportFileDetails_RQ RQ = new MDMSVC.DC_SupplierImportFileDetails_RQ();
SelectedSupplierImportAttributeValue_Id = myRowId;
SupplierImportFile_Id = myRowId;
RQ.SupplierImportFile_Id = myRowId;
RQ.PageNo = 0;
RQ.PageSize = int.MaxValue;
var res = _objMappingSVCs.GetSupplierStaticFileDetails(RQ);
SelectedSupplierImportAttributeValue_Id = myRowId;
obj.SupplierImportFile_Id = res[0].SupplierImportFile_Id;
obj.Supplier_Id = res[0].Supplier_Id;
obj.Supplier = res[0].Supplier;
obj.SavedFilePath = res[0].SavedFilePath;
obj.PROCESS_USER = System.Web.HttpContext.Current.User.Identity.Name;
obj.Entity = res[0].Entity;
obj.STATUS = res[0].STATUS;
obj.Mode = res[0].Mode;
var result = _objMappingSVCs.StaticFileUploadProcessFile(obj);
fillmatchingdata(Convert.ToInt32(ddlShowEntries.SelectedItem.Text), gvFileUploadSearch.PageIndex);
BootstrapAlert.BootstrapAlertMessage(dvMsg, result.StatusMessage, (BootstrapAlertType)result.StatusCode);
}
if (e.CommandName == "SoftDelete")
{
MDMSVC.DC_SupplierImportFileDetails_RQ RQ = new MDMSVC.DC_SupplierImportFileDetails_RQ();
RQ.SupplierImportFile_Id = myRowId;
RQ.PageNo = 0;
RQ.PageSize = int.MaxValue;
var res = _objMappingSVCs.GetSupplierStaticFileDetails(RQ);
MDMSVC.DC_SupplierImportFileDetails obj = new MDMSVC.DC_SupplierImportFileDetails
{
SupplierImportFile_Id = myRowId,
STATUS = res[0].STATUS,
PROCESS_DATE = DateTime.Now,
PROCESS_USER = System.Web.HttpContext.Current.User.Identity.Name,
IsActive = false
};
var result = _objMappingSVCs.UpdateSupplierStaticFileDetails(obj);
fillmatchingdata(Convert.ToInt32(ddlShowEntries.SelectedItem.Text), 0);
BootstrapAlert.BootstrapAlertMessage(dvMsg, "File has been deleted Successfully", (BootstrapAlertType)result.StatusCode);
}
if (e.CommandName == "UnDelete")
{
MDMSVC.DC_SupplierImportFileDetails_RQ RQ = new MDMSVC.DC_SupplierImportFileDetails_RQ();
RQ.SupplierImportFile_Id = myRowId;
RQ.PageNo = 0;
RQ.PageSize = int.MaxValue;
var res = _objMappingSVCs.GetSupplierStaticFileDetails(RQ);
MDMSVC.DC_SupplierImportFileDetails obj = new MDMSVC.DC_SupplierImportFileDetails
{
SupplierImportFile_Id = myRowId,
STATUS = res[0].STATUS,
PROCESS_DATE = DateTime.Now,
PROCESS_USER = System.Web.HttpContext.Current.User.Identity.Name,
IsActive = true
};
var result = _objMappingSVCs.UpdateSupplierStaticFileDetails(obj);
fillmatchingdata(Convert.ToInt32(ddlShowEntries.SelectedItem.Text), 0);
BootstrapAlert.BootstrapAlertMessage(dvMsg, "File has been un deleted Successfully", (BootstrapAlertType)result.StatusCode);
}
}
catch
{
}
}
