public static int Save(Entity.Common.Company Company) { using (DataManager oDm = new DataManager()) { oDm.Add("@pCompanyId", SqlDbType.Int, Company.CompanyId); oDm.Add("@pCompanyName", SqlDbType.VarChar, 150, Company.CompanyName); oDm.Add("@pCompanyAliasName", SqlDbType.VarChar, 150, Company.CompanyAliasName); oDm.Add("@pCompanyAddress", SqlDbType.VarChar, 500, Company.CompanyAddress); oDm.Add("@pCompanyPhoneNo", SqlDbType.VarChar, 15, Company.CompanyPhoneNo); oDm.Add("@pCompanyPhoneFax", SqlDbType.VarChar, 15, Company.CompanyPhoneFax); oDm.Add("@pCompanyEmailId", SqlDbType.VarChar, 50, Company.CompanyEmailId); oDm.Add("@pCompanyPTax", SqlDbType.VarChar, 50, Company.CompanyPTax); oDm.Add("@pCompanyTanNo", SqlDbType.VarChar, 50, Company.CompanyTanNo); oDm.Add("@pCompanyPFNo", SqlDbType.VarChar, 50, Company.CompanyPFNo); oDm.Add("@pCompanyESINo", SqlDbType.VarChar, 50, Company.CompanyESINo); oDm.Add("@pCompanyCIN", SqlDbType.VarChar, 50, Company.CompanyCIN); oDm.Add("@pCompanyVATRegistrationNo", SqlDbType.VarChar, 50, Company.CompanyVATRegistrationNo); oDm.Add("@pCompanyCSTRegistrationNo", SqlDbType.VarChar, 50, Company.CompanyCSTRegistrationNo); oDm.Add("@pCompanySTRegistrationNo", SqlDbType.VarChar, 50, Company.CompanySTRegistrationNo); oDm.Add("@pCompanyWebsite", SqlDbType.VarChar, 50, Company.CompanyWebsite); oDm.Add("@pCompanyContactPersonName", SqlDbType.VarChar, 50, Company.CompanyContactPersonName); oDm.Add("@pCompanyContactPersonNo", SqlDbType.VarChar, 50, Company.CompanyContactPersonNo); oDm.Add("@pCompanyCUser_UserId", SqlDbType.Int, Company.CompanyCUser_UserId); oDm.Add("@pCompanyType", SqlDbType.VarChar, 50, Company.CompanyType); oDm.Add("@pCompanyPANNo", SqlDbType.VarChar, 50, Company.CompanyPANNo); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteNonQuery("usp_Company_Save")); } }
protected void LoadCompanyDetails() { BusinessLayer.Common.Company ObjCompany = new BusinessLayer.Common.Company(); Entity.Common.Company Company = new Entity.Common.Company(); Company = ObjCompany.GetAllById(CompanyId); if (Company != null) { txtCompanyName.Text = Company.CompanyName; txtCompanyName.Enabled = true; txtAlias.Text = Company.CompanyAliasName; txtAddress.Text = Company.CompanyAddress; txtPhone.Text = Company.CompanyPhoneNo; txtFax.Text = Company.CompanyPhoneFax; txtEmail.Text = Company.CompanyEmailId; txtPTaxNo.Text = Company.CompanyPTax; txtTanNo.Text = Company.CompanyTanNo; txtPFNo.Text = Company.CompanyPFNo; txtESINo.Text = Company.CompanyESINo; txtCINNo.Text = Company.CompanyCIN; txtVatRegnNo.Text = Company.CompanyVATRegistrationNo; txtCSTRegnNo.Text = Company.CompanyCSTRegistrationNo; txtSTRegnNo.Text = Company.CompanySTRegistrationNo; txtWebsite.Text = Company.CompanyWebsite; txtContactPerson.Text = Company.CompanyContactPersonName; txtContactPersonNo.Text = Company.CompanyContactPersonNo; ddlCompanyType.SelectedValue = Company.CompanyType; txtPANNo.Text = Company.CompanyPANNo; Message.Show = false; btnSave.Text = "Update"; } }
private string GetCompanyType() { int CompanyId = Convert.ToInt32(Session["CompanyId"].ToString()); BusinessLayer.Common.Company ObjCompany = new BusinessLayer.Common.Company(); Entity.Common.Company Company = new Entity.Common.Company(); Company = ObjCompany.GetAllById(CompanyId); if (Company != null) { return("/" + Company.CompanyType); } else { return(""); } }
protected void btnSave_Click(object sender, EventArgs e) { BusinessLayer.Common.Company ObjCompany = new BusinessLayer.Common.Company(); Entity.Common.Company Company = new Entity.Common.Company(); Company.CompanyId = CompanyId; Company.CompanyName = txtCompanyName.Text.Trim(); Company.CompanyAliasName = txtAlias.Text.Trim(); Company.CompanyAddress = txtAddress.Text.Trim(); Company.CompanyPhoneNo = txtPhone.Text.Trim(); Company.CompanyPhoneFax = txtFax.Text.Trim(); Company.CompanyEmailId = txtEmail.Text.Trim(); Company.CompanyPTax = txtPTaxNo.Text.Trim(); Company.CompanyTanNo = txtTanNo.Text.Trim(); Company.CompanyPFNo = txtPFNo.Text.Trim(); Company.CompanyESINo = txtESINo.Text.Trim(); Company.CompanyCIN = txtCINNo.Text.Trim(); Company.CompanyVATRegistrationNo = txtVatRegnNo.Text.Trim(); Company.CompanyCSTRegistrationNo = txtCSTRegnNo.Text.Trim(); Company.CompanySTRegistrationNo = txtSTRegnNo.Text.Trim(); Company.CompanyWebsite = txtWebsite.Text.Trim(); Company.CompanyContactPersonName = txtContactPerson.Text.Trim(); Company.CompanyContactPersonNo = txtContactPersonNo.Text.Trim(); Company.CompanyType = ddlCompanyType.SelectedValue.Trim(); Company.CompanyPANNo = txtPANNo.Text.Trim(); Company.CompanyCUser_UserId = int.Parse(HttpContext.Current.User.Identity.Name); int RowsAffected = ObjCompany.Save(Company); if (RowsAffected != -1) { ClearControls(); LoadCompanyList(); Message.IsSuccess = true; Message.Text = "Company Configuration Saved Successfully"; } else { Message.IsSuccess = false; Message.Text = "Can Not save. Duplicate Company Name Is Not Allowed"; } Message.Show = true; }
public static Entity.Common.Company GetAllById(int CompanyId) { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; oDm.Add("@pCompanyId", SqlDbType.Int, CompanyId); SqlDataReader dr = oDm.ExecuteReader("usp_Company_GetAllById"); Entity.Common.Company Company = new Entity.Common.Company(); if (dr.HasRows) { while (dr.Read()) { Company.CompanyId = CompanyId; Company.CompanyName = (dr[1] == DBNull.Value) ? "" : dr[1].ToString(); Company.CompanyAliasName = (dr[2] == DBNull.Value) ? "" : dr[2].ToString(); Company.CompanyAddress = (dr[3] == DBNull.Value) ? "" : dr[3].ToString(); Company.CompanyPhoneNo = (dr[4] == DBNull.Value) ? "" : dr[4].ToString(); Company.CompanyPhoneFax = (dr[5] == DBNull.Value) ? "" : dr[5].ToString(); Company.CompanyEmailId = (dr[6] == DBNull.Value) ? "" : dr[6].ToString(); Company.CompanyPTax = (dr[7] == DBNull.Value) ? "" : dr[7].ToString(); Company.CompanyTanNo = (dr[8] == DBNull.Value) ? "" : dr[8].ToString(); Company.CompanyPFNo = (dr[9] == DBNull.Value) ? "" : dr[9].ToString(); Company.CompanyESINo = (dr[10] == DBNull.Value) ? "" : dr[10].ToString(); Company.CompanyCIN = (dr[11] == DBNull.Value) ? "" : dr[11].ToString(); Company.CompanyVATRegistrationNo = (dr[12] == DBNull.Value) ? "" : dr[12].ToString(); Company.CompanyCSTRegistrationNo = (dr[13] == DBNull.Value) ? "" : dr[13].ToString(); Company.CompanySTRegistrationNo = (dr[14] == DBNull.Value) ? "" : dr[14].ToString(); Company.CompanyWebsite = (dr[15] == DBNull.Value) ? "" : dr[15].ToString(); Company.CompanyContactPersonName = (dr[16] == DBNull.Value) ? "" : dr[16].ToString(); Company.CompanyContactPersonNo = (dr[17] == DBNull.Value) ? "" : dr[17].ToString(); Company.CompanyType = (dr[18] == DBNull.Value) ? "None" : dr[18].ToString(); Company.CompanyPANNo = (dr[19] == DBNull.Value) ? "" : dr[19].ToString(); } } return(Company); } }
public int Save(Entity.Common.Company Company) { return(DataAccess.Common.Company.Save(Company)); }