public static string GetOrderData(String ordNo, string system, string company)
{
clsOrderData odm = new clsOrderData();
odm.orderNumber = ordNo.ToUpper();
if (company == "0" && system == "0")
{
odm = Helper.getCurriesOrderData(odm);
}
else if (company == "1" && system == "0")
{
odm = Helper.getGrahamOrderData(odm);
}
else if (company == "2" && system == "0")
{
odm = Helper.getCecoOrderData(odm);
}
else if (company == "3" && system == "0")
{
odm = Helper.getFrameworksOrderData(odm);
}
string details;
if (odm.distNumber != null && !odm.distNumber.Trim().Equals(""))
{
details = odm.distNumber + "*" + odm.branch + "*" + odm.poNumber + "*" + odm.status;
}
else
{
details = "0";
}
return(details);
}
public static string GetOrderData(String ordNo,string system,string company)
{
clsOrderData odm = new clsOrderData();
odm.orderNumber = ordNo.ToUpper();
if (company=="0" && system =="0")
{
odm = Helper.getCurriesOrderData(odm);
}
else if (company == "1" && system == "0")
{
odm = Helper.getGrahamOrderData(odm);
}
else if (company == "2" && system == "0")
{
odm = Helper.getCecoOrderData(odm);
}
else if (company == "3" && system == "0")
{
odm = Helper.getFrameworksOrderData(odm);
}
string details;
if (odm.distNumber != null && !odm.distNumber.Trim().Equals(""))
{
details=odm.distNumber+"*"+odm.branch+"*"+odm.poNumber+"*"+odm.status;
}
else
{
details="0";
}
return details;
}
public static clsOrderData validatefile(string filename, string system, string company)
{
clsOrderData orderdata = new clsOrderData();
if (system == "0")
{
string doctype = ProcessOrderData(filename);
string[] b = doctype.Split('*');
string details = GetOrderData(b[0].ToString(), system, company);
string[] c = details.Split('*');
orderdata.orderNumber = b[0].ToString();
orderdata.doctypes = b[1].ToString().ToString();
if (b[2].ToString() != "")
{
orderdata.indexes = b[2].ToString();
}
else
{
orderdata.indexes = "";
}
if (c[0].ToString() != "")
{
orderdata.distNumber = c[0].ToString();
orderdata.branch = c[1].ToString();
orderdata.poNumber = c[2].ToString();
orderdata.status = "1";
orderdata.company = company;
}
else
{
orderdata.status = "0";
}
}
else
{
//ProcessDrawingData(filename);
}
return(orderdata);
}
public static string validempmail(string fileName, string company)
{
bool res = false;
//Int32.TryParse(json.Company,out company);
int system = 0;
//Int32.TryParse(json.System,out system);
String documentType = string.Empty;
String additionalInformation = string.Empty;
String ordNo = string.Empty;
String distributor = string.Empty;
String branch = string.Empty;
String poNumber = string.Empty;
if (!fileName.Equals(""))
{
try
{
ordNo = fileName.Substring(0, fileName.IndexOf("."));
if (ordNo.Contains("-") || (ordNo.Contains("_")))
{
ordNo = ordNo.Replace("_", "-");
String[] ordData;
ordData = ordNo.Split('-');
ordNo = ordData[0];
if (ordData.Length > 1 && !ordData[1].Trim().Equals(""))
{
documentType = Helper.getStringSql(string.Format("SELECT DOCTYPE FROM DOORGRP.W_DOCTYPES WHERE TRIM(DOCCODE) = '{0}'", ordData[1].ToUpper().Trim()), ConfigurationManager.ConnectionStrings["CurriesOleDB"].ConnectionString);
}
else
{
documentType = "Miscellaneous";
}
if (ordData.Length >= 3)
{
additionalInformation = ordData[2];
}
}
if (!ordNo.Equals(""))
{
clsOrderData odm = new clsOrderData();
odm.orderNumber = ordNo.ToUpper();
if (company.Equals("0") && system == 0)
{
odm = Helper.getCurriesOrderData(odm, ConfigurationManager.ConnectionStrings["CurriesOleDB"].ConnectionString);
}
else if (company.Equals("1") && system == 0)
{
odm = Helper.getGrahamOrderData(odm, ConfigurationManager.ConnectionStrings["CurriesOleDB"].ConnectionString);
}
else if (company.Equals("2") && system == 0)
{
odm = Helper.getCecoOrderData(odm, ConfigurationManager.ConnectionStrings["CurriesOleDB"].ConnectionString);
}
else if (company.Equals("3") && system == 0)
{
odm = Helper.getFrameworksOrderData(odm, ConfigurationManager.ConnectionStrings["CurriesOleDB"].ConnectionString);
}
if (odm.distNumber != null && !odm.distNumber.Trim().Equals(""))
{
distributor = odm.distNumber;
branch = odm.branch;
poNumber = odm.poNumber;
String OrderStatus = odm.status;
res = true;
//btnUpload.Enabled = true;
}
else
{
//txtOrdNo.BackColor = Color.Red;
//btnUpload.Enabled = false;
}
}
}
catch (Exception)
{
throw;
}
}
//Adding comma and Sending the Response to JavaScript (AJAX)
string Output = ordNo;
Output = Output + ",";
Output = Output + distributor;
Output = Output + ",";
Output = Output + branch;
Output = Output + ",";
Output = Output + poNumber;
Output = Output + ",";
Output = Output + documentType;
Output = Output + ",";
Output = Output + additionalInformation;
Output = Output + ",";
Output = Output + res.ToString();
return Output;
//string a = "1,2,3,4";
//return a;
}
public static clsOrderData validatefile(string filename, string system,string company)
{
clsOrderData orderdata = new clsOrderData();
if (system == "0")
{
string doctype = ProcessOrderData(filename);
string[] b = doctype.Split('*');
string details=GetOrderData(b[0].ToString(),system,company);
string[] c = details.Split('*');
orderdata.orderNumber = b[0].ToString();
orderdata.doctypes = b[1].ToString().ToString();
if (b[2].ToString() != "")
{
orderdata.indexes = b[2].ToString();
}
else
{
orderdata.indexes = "";
}
if (c[0].ToString() != "")
{
orderdata.distNumber = c[0].ToString();
orderdata.branch = c[1].ToString();
orderdata.poNumber = c[2].ToString();
orderdata.status = "1";
orderdata.company = company;
}
else
{
orderdata.status = "0";
}
}
else
{
//ProcessDrawingData(filename);
}
return orderdata;
}
