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);
}
private void fillmatchingdataForNew(int PageSize, int PageNo)
{
//lblTotalRecords.Text = string.Empty;
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;
}
RQParam.PageNo = PageNo;
RQParam.PageSize = PageSize;
RQParam.STATUS = "NEW";
var res = _objMappingSVCs.GetSupplierStaticFileDetails(RQParam);
if (res != null)
{
if (res.Count > 0)
{
gvFileUploadSearchForNew.VirtualItemCount = res[0].TotalRecords;
gvFileUploadSearchForNew.DataSource = (from a in res orderby a.CREATE_DATE descending select a).ToList();
gvFileUploadSearchForNew.PageIndex = PageNo;
gvFileUploadSearchForNew.PageSize = 10;//Convert.ToInt32(ddlShowEntries.SelectedItem.Text);
gvFileUploadSearchForNew.DataBind();
btnUploadCompleted.Visible = true;
//lblTotalRecords.Text = res[0].TotalRecords.ToString();
}
else
{
gvFileUploadSearchForNew.DataSource = null;
gvFileUploadSearchForNew.DataBind();
btnUploadCompleted.Visible = false;
}
//btnUploadCompleted.Style.Add("display", "");
}
else
{
gvFileUploadSearchForNew.DataSource = null;
gvFileUploadSearchForNew.DataBind();
btnUploadCompleted.Visible = false;
//lblTotalRecords.Text = string.Empty;
}
}
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);
}
}
private void fillmatchingdata(int PageSize, int PageNo)
{
lblTotalRecords.Text = string.Empty;
MDMSVC.DC_SupplierImportFileDetails_RQ RQParam = new MDMSVC.DC_SupplierImportFileDetails_RQ();
if (ddlSupplierName.SelectedItem.Value != "0")
{
RQParam.Supplier_Id = Guid.Parse(ddlSupplierName.SelectedItem.Value);
}
if (ddlMasterCountry.SelectedItem.Value != "0")
{
RQParam.Entity = ddlMasterCountry.SelectedItem.Text;
}
if (ddlStatus.SelectedItem.Value != "0")
{
RQParam.STATUS = ddlStatus.SelectedItem.Text;
}
if (txtFrom.Text != String.Empty && txtTo.Text != String.Empty)
{
RQParam.From_Date = DateTime.Parse(txtFrom.Text);
RQParam.TO_Date = DateTime.Parse(txtTo.Text).AddDays(1); //added 1 day to include all the files added on 'To date' (upto time '23:59:59' by default it takes '00:00:00')
}
RQParam.PageNo = PageNo;
RQParam.PageSize = PageSize;
var res = _objMappingSVCs.GetSupplierStaticFileDetails(RQParam);
if (res != null)
{
if (res.Count > 0)
{
gvFileUploadSearch.VirtualItemCount = res[0].TotalRecords;
lblTotalRecords.Text = res[0].TotalRecords.ToString();
}
gvFileUploadSearch.DataSource = (from a in res orderby a.CREATE_DATE descending select a).ToList();
gvFileUploadSearch.PageIndex = PageNo;
gvFileUploadSearch.PageSize = Convert.ToInt32(ddlShowEntries.SelectedItem.Text);
gvFileUploadSearch.DataBind();
}
else
{
gvFileUploadSearch.DataSource = null;
gvFileUploadSearch.DataBind();
lblTotalRecords.Text = string.Empty;
}
}
private void fillmatchingdataArchive(int PageSize, int PageNo)
{
MDMSVC.DC_SupplierImportFileDetails_RQ RQParam = new MDMSVC.DC_SupplierImportFileDetails_RQ();
if (ddlSupplierName.SelectedItem.Value != "0")
{
RQParam.Supplier_Id = Guid.Parse(ddlSupplierName.SelectedItem.Value);
}
if (ddlMasterCountry.SelectedItem.Value != "0")
{
RQParam.Entity = ddlMasterCountry.SelectedItem.Text;
}
if (ddlStatus.SelectedItem.Value != "0")
{
RQParam.STATUS = ddlStatus.SelectedItem.Text;
}
RQParam.PageNo = PageNo;
RQParam.PageSize = PageSize;
var res = _objMappingSVCs.GetSupplierStaticFileDetails(RQParam);
if (res != null)
{
if (res.Count > 0)
{
gvFileUploadSearch.VirtualItemCount = res[0].TotalRecords;
lblTotalRecords.Text = res[0].TotalRecords.ToString();
}
gvFileUploadSearch.DataSource = (from a in res orderby a.CREATE_DATE descending select a).ToList();
gvFileUploadSearch.PageIndex = PageNo;
gvFileUploadSearch.PageSize = Convert.ToInt32(ddlShowEntries.SelectedItem.Text);
gvFileUploadSearch.DataBind();
BootstrapAlert.BootstrapAlertMessage(dvMsg, "File has been archived successfully.", BootstrapAlertType.Success);
}
else
{
gvFileUploadSearch.DataSource = null;
gvFileUploadSearch.DataBind();
lblTotalRecords.Text = string.Empty;
}
}
protected void updateData(DC_SupplierImportFileDetails request)
{
MDMSVC.DC_SupplierImportFileDetails_RQ RQ = new MDMSVC.DC_SupplierImportFileDetails_RQ();
if (request != null)
{
RQ.SupplierImportFile_Id = request.SupplierImportFile_Id;
RQ.PageNo = 0;
RQ.PageSize = int.MaxValue;
var res = mappingsvc.GetSupplierStaticFileDetails(RQ);
request.Supplier_Id = res[0].Supplier_Id;
request.Supplier = res[0].Supplier;
request.SavedFilePath = res[0].SavedFilePath;
request.PROCESS_USER = System.Web.HttpContext.Current.User.Identity.Name;
request.Entity = res[0].Entity;
request.STATUS = res[0].STATUS;
request.Mode = res[0].Mode;
request.CurrentBatch = res[0].CurrentBatch;
var result = mappingsvc.UpdateSupplierImportFileDeails(request);
}
}
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
{
}
}
//Get
public List <MDMSVC.DC_SupplierImportFileDetails> GetSupplierStaticFileDetails(MDMSVC.DC_SupplierImportFileDetails_RQ RQ)
{
object result = null;
ServiceConnection.MDMSvcProxy.PostData(ConfigurationManager.AppSettings["SupplierFileDetails_Get"], RQ, typeof(MDMSVC.DC_SupplierImportFileDetails_RQ), typeof(List <MDMSVC.DC_SupplierImportFileDetails>), out result);
return(result as List <MDMSVC.DC_SupplierImportFileDetails>);
}
