private MyKeyValuePair GetValue()
{
var kv = new MyKeyValuePair()
{
Value = "Project Not Find",
Key = 0
};
if (_row == null)
{
return(kv);
}
var jobNumber = Convert.ToString(_row["jobNumber"]);
var subProject = MyConvert.ConvertToInteger(_row["subProject"]);
if (subProject > 0)
{
jobNumber += "-" + subProject;
}
kv.Value = jobNumber.ToUpper() + " - " + Convert.ToString(_row["jobTitle"]);
kv.Key = Convert.ToInt32(_row["jobID"]);
return(kv);
}
private string SearchType(string q)
{
string searchType = "ProjectText";
string s1 = MyString.Left(q, 2);
if (MyConvert.ConvertToInteger(s1) >= 10)
{
string s2 = MyString.Left(q, 3);
if (s2.ToUpper().Contains("P"))
{
searchType = "Project";
}
if (s2.ToUpper().Contains("J"))
{
searchType = "WorkorderByNumber";
}
if (s2.ToUpper().Contains("V"))
{
searchType = "InvoiceByNumber";
}
}
return(searchType);
}
public MaterialCategorySearchVm(string q, string typeText, string parentID, string parentText)
{
var pID = MyConvert.ConvertToInteger(parentID);
IAutoCompleteReponses vm;
var typeID = Convert.ToInt32(typeText);
switch (typeID)
{
case 0:
vm = new MaterialCategoryVm0();
break;
case 1:
vm = new MaterialCategoryVm1(pID, parentText);
break;
case 2:
vm = new MaterialCategoryVm2(pID, parentText);
break;
default:
vm = new MaterialCategoryVm3(pID, parentText);
break;
}
Values = vm.Values;
}
public override int Validate()
{
var v = (int)NWorkorderValidationError.Validated;
DataTable tbl = WorkorderShared.getExistingWorkorderItems(_woID);
//any item has a zero leadtie will cause the error
int leadtime = 0;
if (tbl != null)
{
foreach (DataRow row in tbl.Rows)
{
if (!Convert.IsDBNull(row["Leadtime"]))
{
leadtime = MyConvert.ConvertToInteger(row["Leadtime"]);
if (leadtime == 0)
{
v = (int)NWorkorderValidationError.ItemLeadtimeRequired;
break;
}
}
}
}
return(v);
}
public virtual void CopyItems(int myParentID, DataSet ds1, DataTable tblItems)
{
foreach (DataRow row in tblItems.Rows)
{
if (Convert.ToBoolean(row["isFinal"]))
{
DataRow rowNew = ds1.Tables["t1"].NewRow();
rowNew["woID"] = _myParentID;
rowNew["estItemID"] = MyConvert.ConvertToInteger(row["estItemID"]);
rowNew["estItemNameText"] = MyConvert.ConvertToString(row["estItemNameText"]);
string copyDetails = SalesCenterConfiguration.CopyDetailsToWorkorder;
if (copyDetails.Trim().ToLower() == "yes")
{
rowNew["woDescription"] = MyConvert.ConvertToString(row["Description"]);
}
else
{
rowNew["woDescription"] = DBNull.Value;
}
rowNew["woPrintOrder"] = MyConvert.ConvertToInteger(row["PrintOrder"]);
rowNew["qty"] = MyConvert.ConvertToInteger(row["qty"]);
rowNew["qtyPC"] = MyConvert.ConvertToInteger(row["qtyPC"]);
rowNew["heightFromGround"] = MyConvert.ConvertToString(row["heightFromGround"]);
int requirement = MyConvert.ConvertToInteger(row["Requirement"]);
if (requirement < 10)
{
requirement = 10;
}
rowNew["Requirement"] = requirement;
rowNew["Position"] = "Outdoor";
if (!Convert.IsDBNull(row["Position"]))
{
rowNew["Position"] = row["Position"];
}
rowNew["fromWhere"] = NGenerateTitleFrom.Estimation;
rowNew["scHydroInspectionRequired"] = false;
rowNew["scPurpose"] = 0;
rowNew["scPurpose1"] = false;
rowNew["scPurpose2"] = false;
rowNew["scPurpose3"] = false;
rowNew["scPurpose4"] = false;
//Item ID
rowNew["nameDetailsID"] = row["nameDetailsID"];
rowNew["qiAmount"] = MyConvert.ConvertToDouble(row["estimatorPrice"]);
string s = "E" + string.Format("{0:D2}", row["SerialID"]);
rowNew["SerialID"] = s;
rowNew["BySubcontractor"] = row["BySubcontractor"];
ds1.Tables["t1"].Rows.Add(rowNew);
}
}
}
public override int GetLeadtime()
{
int ltDays = 0;
string s = SalesCenterConfiguration.LeadtimeSiteCheck;
ltDays = MyConvert.ConvertToInteger(s);
return(ltDays);
}
public override object GetFieldValue(DataRow row)
{
var i = (int)EmployeeEN.NEmployeeIDDefault.NullSales110;
if (!Convert.IsDBNull(row["Sales"]))
{
i = MyConvert.ConvertToInteger(row["Sales"]);
}
return(i);
}
public override object GetFieldValue(DataRow row)
{
int i = 0;
if (!Convert.IsDBNull(row["WoType"]))
{
i = MyConvert.ConvertToInteger(row["WoType"]);
}
return(i);
}
private void InitializationProperties(DataRow row)
{
if (row == null)
{
return;
}
JobId = MyConvert.ConvertToInteger(row["jobID"]);
WorkedHour = MyConvert.ConvertToDouble(row["workedHour"]);
FinishedDate = MyConvert.ConvertToDate(row["FinishedDate"]);
NumberOfDrawing = MyConvert.ConvertToInteger(row["NumberOfDrawing"]);
Note = MyConvert.ConvertToString(row["Note"]);
}
private int GetTermID()
{
int termID = 0;
//COD
if (!Convert.IsDBNull(_row["termID"]))
{
if (Convert.ToInt32(_row["termID"]) < 1000)
{
termID = MyConvert.ConvertToInteger(_row["termID"]);
}
}
return(termID);
}
public SpecServiceAllGroup()
{
Values = new List <MyKeyValuePair>();
var tbl = GetAvailableServiceGroup();
if (tbl == null)
{
return;
}
foreach (DataRow row in tbl.Rows)
{
var kvp = new MyKeyValuePair();
kvp.Key = MyConvert.ConvertToInteger(row["Value"]);
kvp.Value = Convert.ToString(row["Text"]);
Values.Add(kvp);
}
}
private void UpdateWorkOrderCopyToRedo()
{
int rowsAffected = 0;
var ConnectionSQL = new SqlConnection(SalesCenterConfiguration.ConnectionString);
string SqlSelectString = "Select woID, redo,redoVer,woRev, WorkorderAmount, PayMethods FROM Sales_JobMasterList_WO WHERE (woID= @woID)";
var SelectCommand = new SqlCommand(SqlSelectString, ConnectionSQL);
var adapter1 = new SqlDataAdapter(SelectCommand);
var ds1 = new DataSet();
ds1.Tables.Clear();
adapter1.SelectCommand.Parameters.Add("@woID", SqlDbType.Int).Value = NewWoID;
try
{
ConnectionSQL.Open();
rowsAffected = adapter1.Fill(ds1, "t1");
if (rowsAffected > 0)
{
DataRow row = ds1.Tables["t1"].Rows[0];
//Revision=1
row["woRev"] = 1;
row["redo"] = true;
row["redoVer"] = MyConvert.ConvertToInteger(row["redoVer"]) + 1;
row["WorkorderAmount"] = 0;
row["PayMethods"] = (int)NPaymentMethods.NoChargeOther;
//1.3. Write back to DB
var cb = new SqlCommandBuilder(adapter1);
adapter1 = cb.DataAdapter;
rowsAffected += adapter1.Update(ds1, "t1");
}
}
catch (SqlException ex)
{
string errorLog = ex.Message;
}
finally
{
ConnectionSQL.Close();
}
}
//Single Size
private bool IsSizeValidated(EST_Item_Specification_Size size)
{
var b = true;
if (size.IsWidthMandatory)
{
if (MyConvert.ConvertToInteger(size.WidthFeet) == 0 && MyConvert.IsNullString(size.WidthInch))
{
b = false;
}
}
if (size.IsHeightEnabled)
{
if (MyConvert.ConvertToInteger(size.WidthFeet) == 0 && MyConvert.IsNullString(size.WidthInch))
{
b = false;
}
}
if (size.IsThicknessEnabled)
{
if (MyConvert.ConvertToInteger(size.HeightFeet) == 0 && MyConvert.IsNullString(size.HeightInch))
{
b = false;
}
}
if (size.IsPcEnabled)
{
if (MyConvert.ConvertToDouble(size.Pc) < 1)
{
b = false;
}
}
return(b);
}
public override void UpdateMisc()
{
int rowsAffected = 0;
var ConnectionSQL = new SqlConnection(SalesCenterConfiguration.ConnectionString);
string SqlSelectString = "Select woID,revise,reviseVer FROM Sales_JobMasterList_WO WHERE (woID= @woID)";
var SelectCommand = new SqlCommand(SqlSelectString, ConnectionSQL);
var adapter1 = new SqlDataAdapter(SelectCommand);
var ds1 = new DataSet();
ds1.Tables.Clear();
adapter1.SelectCommand.Parameters.Add("@woID", SqlDbType.Int).Value = NewWoID;
try
{
ConnectionSQL.Open();
rowsAffected = adapter1.Fill(ds1, "t1");
if (rowsAffected > 0)
{
DataRow row = ds1.Tables["t1"].Rows[0];
row["revise"] = true;
row["reviseVer"] = MyConvert.ConvertToInteger(row["reviseVer"]) + 1;
//1.3. Write back to DB
var cb = new SqlCommandBuilder(adapter1);
adapter1 = cb.DataAdapter;
rowsAffected += adapter1.Update(ds1, "t1");
}
}
catch (SqlException ex)
{
string errorLog = ex.Message;
}
finally
{
ConnectionSQL.Close();
}
}
public void Generate()
{
DataTable tbl = EstItemCommon.GetEstimationItems(_estRevID);
if (tbl != null)
{
//
//2. Define the destination: InvoiceItem
var connectionSQL = new SqlConnection(SalesCenterConfiguration.ConnectionString);
const string sqlSelectString2 = "SELECT * FROM [Invoice_Item] WHERE ([quoteItemID] = 0) ";
var selectCommand2 = new SqlCommand(sqlSelectString2, connectionSQL);
var adapter2 = new SqlDataAdapter(selectCommand2);
var ds2 = new DataSet();
ds2.Tables.Clear();
try
{
connectionSQL.Open();
//define row
adapter2.Fill(ds2, "t2");
foreach (DataRow row in tbl.Rows)
{
DataRow rowNew = ds2.Tables["t2"].NewRow();
rowNew["quoteRevID"] = _invoiceID;
int fwJobTypeRequriedmentID = Convert.ToInt32(row["RequirementID"]);
var sp = new SupplyType(fwJobTypeRequriedmentID);
rowNew["supplyType"] = sp.QuoteSupplyTypeID;
rowNew["qiPrintOrder"] = row["estItemNo"];
rowNew["quoteOption"] = row["ItemOption"];
rowNew["isFinal"] = row["isFinalOption"];
rowNew["estItemID"] = row["estItemID"];
rowNew["qiItemTitle"] = row["ProductName"];
string copyDetails = SalesCenterConfiguration.CopyDetailsToInvoice;
if (copyDetails.Trim().ToLower() == "yes")
{
rowNew["qiDescription"] = row["Description"];
}
else
{
rowNew["qiDescription"] = DBNull.Value;
}
rowNew["recordType"] = "I";
rowNew["qiQty"] = row["Qty"];
rowNew["qiQtyPC"] = row["QtyPc"];
double qiAmount = MyConvert.ConvertToDouble(row["estimatorPrice"]);
rowNew["qiAmount"] = qiAmount;
rowNew["qiUnitPrice"] = 0;
//to be defined in estimation
rowNew["estItemID"] = row["estItemID"];
rowNew["Requirement"] = row["RequirementID"];
//rowNew["Position"] = row["Position"];
rowNew["Position"] = "Indoor";
int s = MyConvert.ConvertToInteger(row["SerialID"]);
rowNew["SerialID"] = "E" + string.Format("{0:D2}", s);
rowNew["nameDetailsID"] = row["ProductID"];
ds2.Tables["t2"].Rows.Add(rowNew);
}
//4. Write ds2, back to DB
var cb = new SqlCommandBuilder(adapter2);
adapter2 = cb.DataAdapter;
adapter2.Update(ds2, "t2");
}
catch (SqlException ex)
{
string errorLog = ex.Message;
}
finally
{
connectionSQL.Close();
}
}
}
public int GetPayrollNumber()
{
return(MyConvert.ConvertToInteger(_row["PayrollNumber"]));
}
public int GetSpecailLeadtime()
{
return(MyConvert.ConvertToInteger(SalesCenterConfiguration.LeadtimeSpecialSample));
}
public QuoteItemReportAdd_Product(DataTable tbl, int quoteRevID)
{
try
{
DataTable tbl2 = GetItemsList(quoteRevID);
DataTable tbl3 = GetItemsGroupByPrintOrder(quoteRevID);
if (tbl2 != null & tbl3 != null)
{
//row Data
foreach (DataRow row in tbl2.Rows)
{
int printOrder = Convert.ToInt32(row["qiPrintOrder"]);
int optionCount = GetOptionCount(printOrder, tbl3);
DataRow rowNew = tbl.NewRow();
//row New
rowNew["PrintOrder"] = AddPrintOrderBaseNumber(printOrder);
row["qiAmountText"] = ConvertToF2Format(row["qiAmountText"]);
QuoteItemPrintFormat qiTO = GetQuoteItemPrintFormat(row, optionCount);
rowNew["Title"] = qiTO.qiTitle;
if (!Convert.IsDBNull(row["SerialID"]))
{
string str = Convert.ToString(row["SerialID"]).Trim();
if (str.Length == 3)
{
rowNew["Title"] = qiTO.qiTitle + " (ID# " + str + ")";
}
else
{
var id1 = MyConvert.ConvertToInteger(row["SerialID"]);
if (id1 > 0)
{
rowNew["Title"] = qiTO.qiTitle + " (ID# E" + id1.ToString("D2") + ")";
}
}
}
rowNew["QuoteOption"] = qiTO.qiOption;
rowNew["HtmlAmount"] = qiTO.HtmlTitleAmount;
rowNew["HtmlAmountOption"] = qiTO.HtmlOptionAmount;
rowNew["Description"] = qiTO.Description;
if (!MyConvert.IsNullString(row["qiAmount"]))
{
string sq1 = MyConvert.ConvertToString(row["qiAmount"]);
if (MyConvert.IsAccountingFormatNumberic(sq1))
{
rowNew["Amount"] = MyConvert.ConvertAccountingFormatStringToDouble(sq1);
}
}
tbl.Rows.Add(rowNew);
}
}
}
catch (SqlException ex)
{
string errorLog = ex.Message;
}
finally
{
}
_tbl = tbl;
}