/// <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!"); } } }