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));
}
