/// <summary>
/// Save Contact Master
/// </summary>
/// <param name="objconmaster"></param>
/// <returns>True/False</returns>
public bool Savecontactmaster(eSunSpeedDomain.ContactmasterModel objconmaster)
{
string Query = string.Empty;
int connectwithledger = 0;
int specifydob = 0;
int specifydateofanniversary = 0;
if (objconmaster.Connectwithledger)
{
connectwithledger = 1;
}
if (objconmaster.SpecifyDateofAnniversary)
{
specifydateofanniversary = 1;
}
if (objconmaster.SpecifyDateofBirth)
{
specifydob = 1;
}
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Name", objconmaster.Name));
paramCollection.Add(new DBParameter("@Alias", objconmaster.AliasName));
paramCollection.Add(new DBParameter("@PrintName", objconmaster.PrintName));
// paramCollection.Add(new DBParameter("@Primary", objconmaster.Primary));
paramCollection.Add(new DBParameter("@Connectwithledger", connectwithledger));
paramCollection.Add(new DBParameter("@Organisation", objconmaster.Organisation));
paramCollection.Add(new DBParameter("@MobileNo", objconmaster.MobileNo));
paramCollection.Add(new DBParameter("@Email", objconmaster.Email));
paramCollection.Add(new DBParameter("@TypeofTrade", objconmaster.TypeofTrade));
paramCollection.Add(new DBParameter("@Group", objconmaster.Group));
paramCollection.Add(new DBParameter("@Area", objconmaster.Area));
paramCollection.Add(new DBParameter("@Department", objconmaster.Department));
paramCollection.Add(new DBParameter("@SpecifyDateofBirth", specifydob));
paramCollection.Add(new DBParameter("@SpecifyDateofAnniversary", specifydateofanniversary));
paramCollection.Add(new DBParameter("@CreatedBy", objconmaster.CreatedBy));
paramCollection.Add(new DBParameter("@Address", objconmaster.Address));
paramCollection.Add(new DBParameter("@Address1", objconmaster.Address1));
paramCollection.Add(new DBParameter("@Address2", objconmaster.Address2));
paramCollection.Add(new DBParameter("@Address3", objconmaster.Address3));
paramCollection.Add(new DBParameter("@PhoneNo", objconmaster.PhoneNo));
paramCollection.Add(new DBParameter("@AFaxNo", objconmaster.FaxNo));
Query = "INSERT INTO CONTACTMASTER (`Name`,`Alias`,`PrintName`,`Connectwithledger`,`Organisation`,`MobileNo`,`Email`,`TypeofTrade`,`Group`," +
"`Area`,`Department`,`SpecifyDateofBirth`,`SpecifyDateofAnniversary`,`Address`,`Address1`,`Address2`,`Address3`,`PhoneNo`,`FaxNo`) " +
"VALUES (@Name,@Alias,@PrintName,@Connectwithledger,@Organisation,@MobileNo,@Email,@TypeofTrade,@Group,@Area,@Department,@SpecifyDateofBirth," +
"@SpecifyDateofAnniversary,@Address,@Address1,@Address2,@Address3,@PhoneNo,@FaxNo)";
return(_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0);
}
private void tbxSave_Click(object sender, EventArgs e)
{
//TODO: 1. Check whether the group name exists or not
//2. if exist then do not allow to save with the same group name
//3. Prompt user to change the group name as it already exists
if (tbxName.Text.Equals(string.Empty))
{
MessageBox.Show("Group Name can not be blank!");
return;
}
//if (objconmtr.IsGroupExists(tbxGName.Text.Trim()))
//{
// MessageBox.Show("Group Name already Exists!", "SunSpeed", MessageBoxButtons.RetryCancel);
// cbxUnderGrp.Focus();
// return;
eSunSpeedDomain.ContactmasterModel objconmas = new eSunSpeedDomain.ContactmasterModel();
objconmas.Name = tbxName.Text.Trim();
objconmas.AliasName = tbxAlias.Text.Trim();
objconmas.PrintName = tbxPrintname.Text.Trim();
objconmas.Connectwithledger = cbxConnectledger.SelectedItem.ToString() == "Y"?true:false;
objconmas.Organisation = tbxOrgination.Text.Trim();
objconmas.MobileNo = tbxMobileno.Text.Trim();
objconmas.Email = tbxEmail.Text.Trim();
objconmas.TypeofTrade = cbxTrade.Text.Trim();
objconmas.Group = cbxGroup.Text.Trim();
objconmas.Area = tbxArea.Text.Trim();
objconmas.Department = tbxDepartment.Text.Trim();
objconmas.SpecifyDateofBirth = cbxSpecifyDoB.SelectedItem.ToString() == "Y" ? true : false;
objconmas.SpecifyDateofAnniversary = cbxDateAnnversary.SelectedItem.ToString() == "Y" ? true : false;
objconmas.Address = tbxAddress.Text.Trim();
objconmas.Address1 = tbxAddress1.Text.Trim();
objconmas.Address2 = tbxEsino.Text.Trim();
objconmas.Address3 = tbxEmailQuery.Text.Trim();
objconmas.PhoneNo = tbxSMSQuery.Text.Trim();
objconmas.FaxNo = tbxContactPerson.Text.Trim();
string message = string.Empty;
bool isSuccess = objconmtr.Savecontactmaster(objconmas);
{
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
}
}
}
