public string InsertITBA(ClsITBA data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
tblITBA oNewRow = new tblITBA()
{
ITBAemail = data.ITBAEmail,
idEmployee = data.idEmployee,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
//UpdatedBy = data.UpdatedBy,
//UpdatedOn = (DateTime?)data.UpdatedOn,
ActiveFlag = data.ActiveFlag,
ReceiveNewReqEmail = data.ReceiveNewReqEmail,
login = data.login
};
puroTouchContext.GetTable <tblITBA>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
//newID = oNewRow.idTaskType;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertVendorType(ClsVendorType data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
tblVendorType oNewRow = new tblVendorType()
{
idVendorType = (Int32)data.idVendorType,
VendorType = data.VendorType,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
//UpdatedBy = data.UpdatedBy,
//UpdatedOn = (DateTime?)data.UpdatedOn,
ActiveFlag = data.ActiveFlag
};
puroTouchContext.GetTable <tblVendorType>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
//newID = oNewRow.idTaskType;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertShippingProduct(ClsShippingProducts data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
tblShippingProduct oNewRow = new tblShippingProduct()
{
ShippingProduct = data.ShippingProduct,
idShippingSvc = data.idShippingSvc,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
//UpdatedBy = data.UpdatedBy,
//UpdatedOn = (DateTime?)data.UpdatedOn,
ActiveFlag = data.ActiveFlag
};
puroTouchContext.GetTable <tblShippingProduct>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
//newID = oNewRow.idTaskType;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static string Insert(clsEDIShipMethod data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
try
{
List <clsEDIShipMethod> qShipMeth = GetEDIShipMethodTypesByidRequest(data.idRequest, data.idEDIShipMethodType);
if (qShipMeth.Count() < 1)
{
tblEDIShipMethod oNewRow = new tblEDIShipMethod()
{
idEDIShipMethodType = data.idEDIShipMethodType,
idRequest = data.idRequest,
ActiveFlag = data.ActiveFlag,
CreatedBy = data.CreatedBy,
CreatedOn = data.CreatedOn
};
puroTouchContext.GetTable <tblEDIShipMethod>().InsertOnSubmit(oNewRow);
puroTouchContext.SubmitChanges();
newID = oNewRow.idEDIShipMethod;
data.idRequest = newID;
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertEDI(ClsDiscoveryRequestEDI data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
try
{
tblDiscoveryRequestEDI oNewRow = new tblDiscoveryRequestEDI()
{
idRequest = (Int32)data.idRequest,
Solution = data.Solution,
FileFormat = data.FileFormat,
CommunicationMethod = data.CommunicationMethod,
UpdatedBy = data.UpdatedBy,
UpdatedOn = data.UpdatedOn,
CreatedBy = data.CreatedBy,
CreatedOn = data.CreatedOn
};
puroTouchContext.GetTable<tblDiscoveryRequestEDI>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
newID = oNewRow.idDREDI;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return errMsg;
}
public string InsertFileUpload(ClsFileUpload data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
try
{
tblDiscoveryRequestUpload oNewRow = new tblDiscoveryRequestUpload()
{
idRequest = (Int32)data.idRequest,
UploadDate = data.UploadDate,
Description = data.Description,
FilePath = data.FilePath,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
ActiveFlag = data.ActiveFlag
};
if (oNewRow.idRequest != 0)
{
puroTouchContext.GetTable <tblDiscoveryRequestUpload>().InsertOnSubmit(oNewRow);
puroTouchContext.SubmitChanges();
newID = oNewRow.idFileUpload;
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string DeleteEDI(int idRequest)
{
string errMsg = "";
try
{
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
var deleteEDI = from details in puroTouchContext.GetTable<tblDiscoveryRequestEDI>()
where details.idRequest == idRequest
select details;
foreach (var idRequestEDI in deleteEDI)
{
puroTouchContext.GetTable<tblDiscoveryRequestEDI>().DeleteOnSubmit(idRequestEDI);
}
try
{
puroTouchContext.SubmitChanges();
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return errMsg;
}
public string InsertEDISolution(ClsEDISolution data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
tblEDISolution oNewRow = new tblEDISolution()
{
Solution = data.Solution,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
//UpdatedBy = data.UpdatedBy,
//UpdatedOn = (DateTime?)data.UpdatedOn,
ActiveFlag = data.ActiveFlag
};
puroTouchContext.GetTable <tblEDISolution>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
//newID = oNewRow.idTaskType;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertEquipment(ClsDiscoveryRequestEquip data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
try
{
tblDiscoveryRequestEquipment oNewRow = new tblDiscoveryRequestEquipment()
{
idRequest = (Int32)data.idRequest,
EquipmentDesc = data.EquipmentDesc,
number = (Int32)data.number,
UpdatedBy = data.UpdatedBy,
UpdatedOn = data.UpdatedOn,
CreatedBy = data.CreatedBy,
CreatedOn = data.CreatedOn
};
puroTouchContext.GetTable <tblDiscoveryRequestEquipment>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
newID = oNewRow.idDREquipment;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static string InsertEDISpecialist(clsEDISpecialist data)
{
string errMsg = "";
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
try
{
tblEDISpecialist oNewRow = new tblEDISpecialist()
{
email = data.email,
idEmployee = data.idEmployee,
CreatedBy = data.CreatedBy,
CreatedOn = DateTime.Now,
//UpdatedBy = data.UpdatedBy,
//UpdatedOn = (DateTime?)data.UpdatedOn,
ActiveFlag = data.ActiveFlag,
ReceiveNewReqEmail = data.ReceiveNewReqEmail,
login = data.login
};
o.GetTable <tblEDISpecialist>().InsertOnSubmit(oNewRow);
o.SubmitChanges();
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static string Insert(clsContact data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
try
{
tblContact oNewRow = new tblContact()
{
idContactType = data.idContactType,
idRequest = data.idRequest,
Name = data.Name,
Title = data.Title,
Phone = data.Phone,
Email = data.Email,
CreatedBy = data.CreatedBy,
CreatedOn = data.CreatedOn
};
puroTouchContext.GetTable <tblContact>().InsertOnSubmit(oNewRow);
puroTouchContext.SubmitChanges();
newID = oNewRow.idContact;
data.idRequest = newID;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertSolutionType(ClsSolutionType data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
ClsSolutionType oNewRow = new ClsSolutionType()
{
SolutionType = data.SolutionType,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn,
//UpdatedBy = data.UpdatedBy,
//UpdatedOn = (DateTime?)data.UpdatedOn,
ActiveFlag = data.ActiveFlag
};
puroTouchContext.GetTable <ClsSolutionType>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertTargetDate(ClsTargetDates data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
tblDiscoveryRequestTargetDate oNewRow = new tblDiscoveryRequestTargetDate()
{
idRequest = (Int32)data.idRequest,
TargetDate = (DateTime)data.TargetDate,
ChangeReason = data.ChangeReason,
CreatedBy = data.CreatedBy,
CreatedOn = (DateTime?)data.CreatedOn
};
puroTouchContext.GetTable <tblDiscoveryRequestTargetDate>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static string Update(clsContact data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
var contact = puroTouchContext.GetTable <tblContact>().Where(f => f.idContact == data.idContact).FirstOrDefault();
if (contact != null)
{
contact.Name = data.Name;
contact.Title = data.Title;
contact.Phone = data.Phone;
contact.Email = data.Email;
contact.UpdatedBy = data.UpdatedBy;
contact.UpdatedOn = data.UpdatedOn;
}
puroTouchContext.SubmitChanges();
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static string UpdateEDIOnboardingPhase(ClsEDIOnboardingPhase data)
{
string errMsg = "";
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
try
{
if (data.idEDIOnboardingPhase > 0)
{
var query = from qdata in o.GetTable <tblEDIOnboardingPhase>()
where qdata.idEDIOnboardingPhase == data.idEDIOnboardingPhase
select qdata;
foreach (tblEDIOnboardingPhase updRow in query)
{
updRow.idEDIOnboardingPhase = data.idEDIOnboardingPhase;
updRow.EDIOnboardingPhaseType = data.EDIOnboardingPhaseType;
updRow.ActiveFlag = data.ActiveFlag;
updRow.UpdatedBy = data.UpdatedBy;
updRow.UpdatedOn = DateTime.Now;
}
o.SubmitChanges();
}
else
{
errMsg = "There is No Shipping Product with ID = " + "'" + data.idEDIOnboardingPhase + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static string Insert(clsExceptionLogging data, out long newID)
{
string errMsg = "";
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
newID = -1;
try
{
tblExceptionLogging oNewRow = new tblExceptionLogging()
{
ExceptionMsg = data.ExceptionMsg,
Method = data.Method,
ExceptionType = data.ExceptionType,
ExceptionSource = data.ExceptionSource,
ExceptionURL = data.ExceptionURL,
CreatedBy = data.CreatedBy,
CreatedOn = data.CreatedOn,
};
o.GetTable <tblExceptionLogging>().InsertOnSubmit(oNewRow);
o.SubmitChanges();
newID = oNewRow.Logid;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string InsertServices(ClsDiscoveryRequestSvcs data, out Int32 newID)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
newID = -1;
try
{
tblDiscoveryRequestService oNewRow = new tblDiscoveryRequestService()
{
idRequest = (Int32)data.idRequest,
idShippingSvc = (Int32)data.idShippingSvc,
volume = (Int32)data.volume,
UpdatedBy = data.UpdatedBy,
UpdatedOn = data.UpdatedOn,
CreatedBy = data.CreatedBy,
CreatedOn = data.CreatedOn
};
puroTouchContext.GetTable <tblDiscoveryRequestService>().InsertOnSubmit(oNewRow);
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
newID = oNewRow.idRequestSvc;
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static string Remove(int idContact)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
var q = puroTouchContext.GetTable <tblContact>().Where(f => f.idContact == idContact).FirstOrDefault();
puroTouchContext.GetTable <tblContact>().DeleteOnSubmit(q);
puroTouchContext.SubmitChanges();
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string UpdateInductionPoint(ClsInductionPoint data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
if (data.idInduction > 0)
{
// Query the database for the row to be updated.
var query =
from qdata in puroTouchContext.GetTable <tblInductionPoint>()
where qdata.idInduction == data.idInduction
select qdata;
// Execute the query, and change the column values
// you want to change.
foreach (tblInductionPoint updRow in query)
{
updRow.Description = data.Description;
updRow.Address = data.Address;
updRow.City = data.City;
updRow.State = data.State;
updRow.Zip = data.Zip;
updRow.Country = data.Country;
updRow.ActiveFlag = data.ActiveFlag;
updRow.PuroPostFlag = data.PuroPostFlag;
updRow.idInduction = data.idInduction;
updRow.UpdatedBy = data.UpdatedBy;
updRow.UpdatedOn = data.UpdatedOn;
}
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
else
{
errMsg = "There is No Induction Point with ID = " + "'" + data.idInduction + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static string Insert(List <clsContact> contactList, Int32 ID)
{
string errMsg = "";
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
try
{
foreach (clsContact c in contactList)
{
tblContact oNewRow = new tblContact()
{
idContactType = c.idContactType,
idRequest = ID,
Name = c.Name,
Title = c.Title,
Phone = c.Phone,
Email = c.Email,
ActiveFlag = true,
CreatedBy = c.CreatedBy,
CreatedOn = DateTime.Now
};
var contact = o.GetTable <tblContact>().Where(f => f.idContactType == c.idContactType && f.idRequest == ID).FirstOrDefault();
if (contact != null)
{
contact.Name = c.Name;
contact.Title = c.Title;
contact.Phone = c.Phone;
contact.Email = c.Email;
contact.ActiveFlag = true;
contact.UpdatedBy = c.CreatedBy;
contact.UpdatedOn = DateTime.Now;
}
else
{
o.GetTable <tblContact>().InsertOnSubmit(oNewRow);
}
o.SubmitChanges();
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string UpdateITBA(ClsITBA data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
if (data.idEmployee > 0)
{
// Query the database for the row to be updated.
var query =
from qdata in puroTouchContext.GetTable <tblITBA>()
where qdata.idEmployee == data.idEmployee
select qdata;
// Execute the query, and change the column values
// you want to change.
foreach (tblITBA updRow in query)
{
updRow.ITBAemail = data.ITBAEmail;
updRow.idEmployee = data.idEmployee;
updRow.ActiveFlag = data.ActiveFlag;
updRow.UpdatedBy = data.UpdatedBy;
updRow.UpdatedOn = data.UpdatedOn;
updRow.ReceiveNewReqEmail = data.ReceiveNewReqEmail;
updRow.login = data.login;
}
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
else
{
errMsg = "There is No Shipping Product with ID = " + "'" + data.idEmployee + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string UpdateNote(ClsNotes data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
if (data.idNote > 0)
{
// Query the database for the row to be updated.
var query =
from qdata in puroTouchContext.GetTable <tblDiscoveryRequestNote>()
where qdata.idNote == data.idNote
select qdata;
// Execute the query, and change the column values
// you want to change.
foreach (tblDiscoveryRequestNote updRow in query)
{
updRow.noteDate = data.noteDate;
updRow.publicNote = data.publicNote;
updRow.idTaskType = data.idTaskType;
updRow.timeSpent = data.timeSpent;
updRow.privateNote = data.privateNote;
updRow.UpdatedBy = data.UpdatedBy;
updRow.UpdatedOn = data.UpdatedOn;
}
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
else
{
errMsg = "There is No Discovery Request Note with idNote = " + "'" + data.idNote + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string UpdateOnboardingPhase(ClsOnboardingPhase data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
if (data.idOnboardingPhase > 0)
{
// Query the database for the row to be updated.
var query =
from qdata in puroTouchContext.GetTable <tblOnboardingPhase>()
where qdata.idOnboardingPhase == data.idOnboardingPhase
select qdata;
// Execute the query, and change the column values
// you want to change.
foreach (tblOnboardingPhase updRow in query)
{
updRow.OnboardingPhase = data.OnboardingPhase;
updRow.ActiveFlag = data.ActiveFlag;
updRow.idOnboardingPhase = data.idOnboardingPhase;
updRow.UpdatedBy = data.UpdatedBy;
updRow.UpdatedOn = data.UpdatedOn;
updRow.SortValue = data.SortValue;
}
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
else
{
errMsg = "There is No Onboarding Phase with ID = " + "'" + data.idOnboardingPhase + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string UpdateShippingProduct(ClsShippingProducts data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
if (data.idShippingSvc > 0)
{
// Query the database for the row to be updated.
var query =
from qdata in puroTouchContext.GetTable <tblShippingProduct>()
where qdata.idShippingProduct == data.idShippingProduct
select qdata;
// Execute the query, and change the column values
// you want to change.
foreach (tblShippingProduct updRow in query)
{
updRow.ShippingProduct = data.ShippingProduct;
updRow.idShippingSvc = data.idShippingSvc;
updRow.ActiveFlag = data.ActiveFlag;
updRow.idShippingProduct = data.idShippingProduct;
updRow.UpdatedBy = data.UpdatedBy;
updRow.UpdatedOn = data.UpdatedOn;
}
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
else
{
errMsg = "There is No Shipping Product with ID = " + "'" + data.idShippingProduct + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string UpdateVendor(ClsThirdPartyVendor data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
if (data.idThirdPartyVendor > 0)
{
// Query the database for the row to be updated.
var query =
from qdata in puroTouchContext.GetTable <tblThirdPartyVendor>()
where qdata.idThirdPartyVendor == data.idThirdPartyVendor
select qdata;
// Execute the query, and change the column values
// you want to change.
foreach (tblThirdPartyVendor updRow in query)
{
updRow.VendorName = data.VendorName;
updRow.ActiveFlag = data.ActiveFlag;
updRow.idThirdPartyVendor = data.idThirdPartyVendor;
updRow.UpdatedBy = data.UpdatedBy;
updRow.UpdatedOn = data.UpdatedOn;
}
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
else
{
errMsg = "There is No Vendor with ID = " + "'" + data.idThirdPartyVendor + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string UpdateCommMethod(ClsCommunicationMethod data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
if (data.idCommunicationMethod > 0)
{
// Query the database for the row to be updated.
var query =
from qdata in puroTouchContext.GetTable <tblCommunicationMethod>()
where qdata.idCommunicationMethod == data.idCommunicationMethod
select qdata;
// Execute the query, and change the column values
// you want to change.
foreach (tblCommunicationMethod updRow in query)
{
updRow.CommunicationMethod = data.CommunicationMethod;
updRow.ActiveFlag = data.ActiveFlag;
updRow.idCommunicationMethod = data.idCommunicationMethod;
updRow.UpdatedBy = data.UpdatedBy;
updRow.UpdatedOn = data.UpdatedOn;
}
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
else
{
errMsg = "There is No Shipping Channel with ID = " + "'" + data.idCommunicationMethod + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string UpdateChangeReason(ClsTargetDates data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
if (data.idTargetDate > 0)
{
// Query the database for the row to be updated.
var query =
from qdata in puroTouchContext.GetTable <tblDiscoveryRequestTargetDate>()
where qdata.idTargetDate == data.idTargetDate
select qdata;
// Execute the query, and change the column values
// you want to change.
foreach (tblDiscoveryRequestTargetDate updRow in query)
{
updRow.ChangeReason = data.ChangeReason;
//updRow.TargetDate = data.TargetDate;
//updRow.idRequest = data.idRequest;
//updRow.CreatedBy = data.CreatedBy;
//updRow.CreatedOn = data.CreatedOn;
}
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
else
{
errMsg = "There is No Row with ID = " + "'" + data.idTargetDate + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public string UpdateFileUpload(ClsFileUpload data)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
if (data.idFileUpload > 0)
{
// Query the database for the row to be updated.
var query =
from qdata in puroTouchContext.GetTable <tblDiscoveryRequestUpload>()
where qdata.idFileUpload == data.idFileUpload
select qdata;
// Execute the query, and change the column values
// you want to change.
foreach (tblDiscoveryRequestUpload updRow in query)
{
updRow.UploadDate = data.UploadDate;
updRow.Description = data.Description;
updRow.FilePath = data.FilePath;
updRow.UpdatedBy = data.UpdatedBy;
updRow.UpdatedOn = data.UpdatedOn;
updRow.ActiveFlag = data.ActiveFlag;
}
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
else
{
errMsg = "There is No File Upload with ID = " + "'" + data.idFileUpload + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
public static string UpdateCollectionSpecialist(clsCollectionSpecialist data)
{
string errMsg = "";
PuroTouchSQLDataContext o = new PuroTouchSQLDataContext();
try
{
if (data.idEmployee > 0)
{
var query = from qdata in o.GetTable <tblCollectionSpecialist>()
where qdata.idEmployee == data.idEmployee
select qdata;
foreach (tblCollectionSpecialist updRow in query)
{
updRow.email = data.email;
updRow.idEmployee = data.idEmployee;
updRow.ActiveFlag = data.ActiveFlag;
updRow.UpdatedBy = data.UpdatedBy;
updRow.UpdatedOn = DateTime.Now;
updRow.ReceiveNewReqEmail = data.ReceiveNewReqEmail;
updRow.login = data.login;
}
// Submit the changes to the database.
o.SubmitChanges();
}
else
{
errMsg = "There is No Shipping Product with ID = " + "'" + data.idEmployee + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
//DELETE A REQUEST (set ActiveFlag to false)
public string deActivateDiscoveryRequest(Int32 requestID, string userName)
{
string errMsg = "";
PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext();
try
{
if (requestID > 0)
{
// Query the database for the row to be updated.
var query =
from qdata in puroTouchContext.GetTable <tblDiscoveryRequest>()
where qdata.idRequest == requestID
select qdata;
// Execute the query, and change the column values
// you want to change.
foreach (tblDiscoveryRequest updRow in query)
{
updRow.ActiveFlag = false;
updRow.UpdatedBy = userName;
updRow.UpdatedOn = DateTime.Now;
}
// Submit the changes to the database.
puroTouchContext.SubmitChanges();
}
else
{
errMsg = "There is No Discovery Request with idRequest = " + "'" + requestID + "'";
}
}
catch (Exception ex)
{
errMsg = ex.Message.ToString();
}
return(errMsg);
}
