public ContactsTask GetContactsDataForID(ContactsTask ContactsObject, string Mode)
{
DataTable ContactsTable = new DataTable();
ContactsTask ReturnContactsObject = new ContactsTask();
try
{
string SqlQuery = "Select ct.* from Contacts ct where ct.ID =" + ContactsObject.ID.ToString();
ContactsTable = objAdaptor.FetchData(SqlQuery);
if (ContactsTable != null && ContactsTable.Rows.Count == 1)
{
ReturnContactsObject.ID = int.Parse(ContactsTable.Rows[0]["ID"].ToString());
ReturnContactsObject.CustID = int.Parse(ContactsTable.Rows[0]["CustID"].ToString());
ReturnContactsObject.ContactName = ContactsTable.Rows[0]["Name"].ToString();
ReturnContactsObject.PhoneNumber = ContactsTable.Rows[0]["PhoneNumber"].ToString();
ReturnContactsObject.Title = ContactsTable.Rows[0]["Title"].ToString();
ReturnContactsObject.Details = ContactsTable.Rows[0]["Details"].ToString();
}
}
catch
{
}
finally
{
}
return(ReturnContactsObject);
}
//insert n update notes/tckets/versioninfo data
//public Object UpdateCustomerData(CustomerTasks CTObject)
//{
// Object Update;
// try
// {
// string SqlQuery = "Update Customer Set Name='" + CTObject.Name + "',Status_Type='" + CTObject.Status_Type +
// "', Address='" + CTObject.Address + "',ServerCount='" + CTObject.ServerCount + "',CompReplacement='" + CTObject.CompReplacement +
// "', OverallStatus='" + CTObject.OverallStatus + "', NextFollowUpDate='" + CTObject.NextFollowUpDate +
// "',LicExpDate='" + CTObject.LicExpDate + "',BudInfo='" + CTObject.BudInfo + "";
// Update = objAdaptor.ExecuteNonQuery(SqlQuery);
// }
// catch
// {
// Update = false;
// }
// finally
// {
// }
// return Update;
//}
public bool UpdateContactsData(ContactsTask ContactsObject, string Mode, string CustId)
{
bool Update;
try
{
string SqlQuery;
if (Mode == "Update")
{
SqlQuery = "Update Contacts Set Name='" + ContactsObject.ContactName + "', PhoneNumber='" + ContactsObject.PhoneNumber +
"', Title='" + ContactsObject.Title + "', Details='" + ContactsObject.Details + "' Where ID = " + ContactsObject.ID;
}
else
{
SqlQuery = "Insert into Contacts Values(" + CustId + ",'" + ContactsObject.ContactName + "','" + ContactsObject.PhoneNumber +
"','" + ContactsObject.Title + "','" + ContactsObject.Details + "')";
}
Update = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
Update = false;
}
finally
{
}
return(Update);
}
private void InsertContact()
{
try
{
bool update = false;
ContactsTask ContactsObject = new ContactsTask();
ContactsTask ReturnContactsObject = new ContactsTask();
ContactsObject.ContactName = ContactNameTextbox.Text;
ContactsObject.PhoneNumber = PhoneNumberTextbox.Text;
ContactsObject.Title = TitleTextbox.Text;
ContactsObject.Details = DetailsTextbox.Text;
update = CustomerServiceBL.CustomerDetails.Ins.UpdateContactsData(ContactsObject, "Insert", CustomerComboBox.SelectedItem.Value.ToString());
if (update)
{
successDiv.Style.Value = "display: block";
errorDiv1.Style.Value = "display: none";
successDiv.InnerText = "New Contact has been successfully created";
}
else
{
successDiv.Style.Value = "display: none";
errorDiv1.Style.Value = "display: block";
errorDiv1.InnerText = "Contact has NOT been created";
}
}
catch (Exception ex)
{ throw ex; }
finally
{
}
}
public DataTable GetAllContactsData()
{
DataTable ContactsDataTable = new DataTable();
ContactsTask ReturnObject = new ContactsTask();
try
{
string SqlQuery = "Select * from Customer, Contacts";
ContactsDataTable = objAdaptor.FetchData(SqlQuery);
}
catch (Exception ex)
{
}
finally
{
}
return(ContactsDataTable);
}
public Object InsertContactsData(ContactsTask ContactsObject)
{
Object Insert = false;
try
{
string SqlQuery = "Insert into Contacts(CustId,Name, PhoneNumber,Title," +
"Details) values (" + ContactsObject.CustID + "'" + ContactsObject.ContactName + "','" + ContactsObject.PhoneNumber + "','" + ContactsObject.Title +
"','" + ContactsObject.Details + "')";
Insert = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
Insert = false;
}
finally
{
}
return(Insert);
}
private void FillContactDetails(int ID)
{
try
{
ContactsTask ContactsObject = new ContactsTask();
ContactsTask ReturnContactsObject = new ContactsTask();
ContactsObject.ID = ID;
ReturnContactsObject = CustomerServiceBL.CustomerDetails.Ins.GetContactsDataForID(ContactsObject, "");
if (ReturnContactsObject != null)
{
ContactNameTextbox.Text = ReturnContactsObject.ContactName.ToString();
PhoneNumberTextbox.Text = ReturnContactsObject.PhoneNumber.ToString();
TitleTextbox.Text = ReturnContactsObject.Title.ToString();
DetailsTextbox.Text = ReturnContactsObject.Details.ToString();
}
}
catch (Exception ex)
{ throw ex; }
finally
{
}
}
//public object UpdateCustomerData(CustomerTasks CTObject)
//{
// Object ReturnValue = ValidateDCUpdate(CTObject);
// if (ReturnValue.ToString() == "")
// {
// return CustomerTrackingDL.CustomerDetails.Ins.UpdateCustomerData(CTObject);
// }
// else return ReturnValue;
//}
public bool UpdateContactsData(ContactsTask CTObject, string Mode, string CustId)
{
return(CustomerTrackingDL.CustomerDetails.Ins.UpdateContactsData(CTObject, Mode, CustId));
}
public ContactsTask GetContactsDataForID(ContactsTask ContactsObject, string mode)
{
return(CustomerTrackingDL.CustomerDetails.Ins.GetContactsDataForID(ContactsObject, mode));
}
