void BindVendorInfo(int id)
{
oblVendorInfo = new Store.VendorInfo.BusinessLogic.VendorInfo();
try
{
objVendorInfo = oblVendorInfo.GetAllVendorInfo(id, 0, "");
if (objVendorInfo != null)
{
hfVendor.Value = objVendorInfo.VendorID.ToString();
txtVendor.Text = objVendorInfo.VendorName;
txtAddress.Text = objVendorInfo.Address;
txtCountry.Text = objVendorInfo.CountryName;
txtState.Text = objVendorInfo.StateName;
txtCity.Text = objVendorInfo.CityName;
txtPin.Text = objVendorInfo.PinID.ToString();
txtMobile.Text = objVendorInfo.MobileNo.ToString();
txtEmail.Text = objVendorInfo.EmailID;
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PReceived).FullName, 1);
}
finally
{
oblVendorInfo = null;
objVendorInfo = null;
}
}
void ManageVendorInfo()
{
objVendorInfo = new Store.VendorInfo.BusinessObject.VendorInfo();
oblVendorInfo = new Store.VendorInfo.BusinessLogic.VendorInfo();
try
{
if (cmdMode == Store.Common.CommandMode.M)
{
objVendorInfo.VendorID = Convert.ToInt32(txtVendorID.Text);
//objVendorInfo.ModifiedBy = Convert.ToInt32(Session["VendorId"]);
}
else
{
objVendorInfo.VendorID = 0;
//objVendorInfo.CreatedBy = Convert.ToInt32(Session["VendorId"]);
}
objVendorInfo.VendorName = Convert.ToString(txtVendorName.Text);
objVendorInfo.VendorDisplayName = Convert.ToString(txtVendorDisplayName.Text);
objVendorInfo.TypeofVendorID = Convert.ToInt32(ddlTypeofVendorID.SelectedItem.Value);
objVendorInfo.Address = Convert.ToString(txtAddress.Text);
objVendorInfo.CityID = Convert.ToInt32(ddlCityID.SelectedItem.Value);
objVendorInfo.StateID = Convert.ToInt32(ddlStateID.SelectedItem.Value);
objVendorInfo.CountryID = Convert.ToInt32(ddlCountryID.SelectedItem.Value);
objVendorInfo.PinID = Convert.ToInt32(txtPinID.Text);
objVendorInfo.ConcernPerson = Convert.ToInt32(txtConcernPerson.Text);
objVendorInfo.PhoneNo = Convert.ToInt32(txtPhoneNo.Text);
objVendorInfo.MobileNo = Convert.ToInt32(txtMobileNo.Text);
objVendorInfo.EmailID = Convert.ToString(txtEmailID.Text);
objVendorInfo.WebsiteAddress = Convert.ToString(txtWebsiteAddress.Text);
objVendorInfo.PanNo = Convert.ToString(txtPanNo.Text);
objVendorInfo.GstNo = Convert.ToString(txtGstNo.Text);
objVendorInfo.ServiceTaxNo = Convert.ToString(txtServiceTaxNo.Text);
if (cbIsActive.Checked)
{
objVendorInfo.IsActive = 1;
}
else
{
objVendorInfo.IsActive = 0;
}
objMessageInfo = oblVendorInfo.ManageItemMaster(objVendorInfo, cmdMode);
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(VendorInfo).FullName, 1);
}
finally
{
objVendorInfo = null;
//objMessageInfo = null;
oblVendorInfo = null;
}
}
public Store.Common.MessageInfo ManageItemMaster(Store.VendorInfo.BusinessObject.VendorInfo objVendorInfo, CommandMode cmdMode)
{
try
{
return(odlVendorInfo.ManageVendorInfo(objVendorInfo, cmdMode));
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(VendorInfo).FullName, 1);
return(null);
}
}
public Store.Common.MessageInfo ManageVendorInfo(Store.VendorInfo.BusinessObject.VendorInfo objVendorInfo, CommandMode cmdMode)
{
string SQL = "";
ParameterList param = new ParameterList();
DataTableReader dr;
Store.Common.MessageInfo objMessageInfo = null;
try
{
SQL = "USP_ManageVendorInfo";
param.Add(new SQLParameter("@VendorID", objVendorInfo.VendorID));
param.Add(new SQLParameter("@VendorName", objVendorInfo.VendorName));
param.Add(new SQLParameter("@VendorDisplayName", objVendorInfo.VendorDisplayName));
param.Add(new SQLParameter("@TypeofVendorID", objVendorInfo.TypeofVendorID));
param.Add(new SQLParameter("@Address", objVendorInfo.Address));
param.Add(new SQLParameter("@CityID", objVendorInfo.CityID));
param.Add(new SQLParameter("@StateID", objVendorInfo.StateID));
param.Add(new SQLParameter("@CountryID", objVendorInfo.CountryID));
param.Add(new SQLParameter("@PinID", objVendorInfo.PinID));
param.Add(new SQLParameter("@ConcernPerson", objVendorInfo.ConcernPerson));
param.Add(new SQLParameter("@PhoneNo", objVendorInfo.PhoneNo));
param.Add(new SQLParameter("@MobileNo", objVendorInfo.MobileNo));
param.Add(new SQLParameter("@EmailID", objVendorInfo.EmailID));
param.Add(new SQLParameter("@WebsiteAddress", objVendorInfo.WebsiteAddress));
param.Add(new SQLParameter("@PanNo", objVendorInfo.PanNo));
param.Add(new SQLParameter("@GstNo", objVendorInfo.GstNo));
param.Add(new SQLParameter("@ServiceTaxNo", objVendorInfo.ServiceTaxNo));
param.Add(new SQLParameter("@IsActive", objVendorInfo.IsActive));
param.Add(new SQLParameter("@ReferenceID", objVendorInfo.ReferenceID));
param.Add(new SQLParameter("@CMDMode", cmdMode));
dr = ExecuteQuery.ExecuteReader(SQL, param);
if (dr.Read())
{
objMessageInfo = new Store.Common.MessageInfo();
objMessageInfo.ErrorCode = Convert.ToInt32(dr["ErrorCode"]);
objMessageInfo.ErrorMessage = Convert.ToString(dr["ErrorMessage"]);
objMessageInfo.TranID = Convert.ToInt32(dr["TranID"]);
objMessageInfo.TranCode = Convert.ToString(dr["TranCode"]);
objMessageInfo.TranMessage = Convert.ToString(dr["TranMessage"]);
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(VendorInfo).FullName, 1);
}
return(objMessageInfo);
}
protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e)
{
cmdMode = CommandMode.D;
objVendorInfo = new Store.VendorInfo.BusinessObject.VendorInfo();
oblVendorInfo = new Store.VendorInfo.BusinessLogic.VendorInfo();
try
{
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
objVendorInfo.VendorID = Convert.ToInt32(dgvVendorInfo.DataKeys[gvrow.RowIndex].Value.ToString());
objVendorInfo.VendorName = "";
objVendorInfo.VendorDisplayName = "";
objVendorInfo.TypeofVendorID = 0;
objVendorInfo.Address = "";
objVendorInfo.CityID = 0;
objVendorInfo.StateID = 0;
objVendorInfo.CountryID = 0;
objVendorInfo.PinID = 0;
objVendorInfo.ConcernPerson = 0;
objVendorInfo.PhoneNo = 0;
objVendorInfo.MobileNo = 0;
objVendorInfo.EmailID = "";
objVendorInfo.WebsiteAddress = "";
objVendorInfo.PanNo = "";
objVendorInfo.GstNo = "";
objVendorInfo.ServiceTaxNo = "";
objVendorInfo.CreatedBy = 1;
objMessageInfo = oblVendorInfo.ManageItemMaster(objVendorInfo, cmdMode);
BindVendorInfo();
updateVendorBdInfo.Update();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('" + objMessageInfo.TranMessage + "')", true);
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(VendorInfo).FullName, 1);
}
finally
{
objVendorInfo = null;
objMessageInfo = null;
oblTypeOfVendor = null;
}
}
public Store.VendorInfo.BusinessObject.VendorInfo GetAllVendorInfo(int VendorInfoID, int Flag, string FlagValue)
{
Store.VendorInfo.BusinessObject.VendorInfo objVendorInfo = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
SQL = "proc_VendorInfo";
paramList.Add(new SQLParameter("@VendorID", VendorInfoID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
objVendorInfo = new BusinessObject.VendorInfo();
if (dr.IsDBNull(dr.GetOrdinal("VendorID")) == false)
{
objVendorInfo.VendorID = dr.GetInt32(dr.GetOrdinal("VendorID"));
}
if (dr.IsDBNull(dr.GetOrdinal("VendorName")) == false)
{
objVendorInfo.VendorName = dr.GetString(dr.GetOrdinal("VendorName"));
}
if (dr.IsDBNull(dr.GetOrdinal("VendorDisplayName")) == false)
{
objVendorInfo.VendorDisplayName = dr.GetString(dr.GetOrdinal("VendorDisplayName"));
}
if (dr.IsDBNull(dr.GetOrdinal("TypeofVendorID")) == false)
{
objVendorInfo.TypeofVendorID = dr.GetInt32(dr.GetOrdinal("TypeofVendorID"));
}
if (dr.IsDBNull(dr.GetOrdinal("Address")) == false)
{
objVendorInfo.Address = dr.GetString(dr.GetOrdinal("Address"));
}
if (dr.IsDBNull(dr.GetOrdinal("CityID")) == false)
{
objVendorInfo.CityID = dr.GetInt32(dr.GetOrdinal("CityID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CityName")) == false)
{
objVendorInfo.CityName = dr.GetString(dr.GetOrdinal("CityName"));
}
if (dr.IsDBNull(dr.GetOrdinal("StateID")) == false)
{
objVendorInfo.StateID = dr.GetInt32(dr.GetOrdinal("StateID"));
}
if (dr.IsDBNull(dr.GetOrdinal("StateName")) == false)
{
objVendorInfo.StateName = dr.GetString(dr.GetOrdinal("StateName"));
}
if (dr.IsDBNull(dr.GetOrdinal("CountryID")) == false)
{
objVendorInfo.CountryID = dr.GetInt32(dr.GetOrdinal("CountryID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CountryName")) == false)
{
objVendorInfo.CountryName = dr.GetString(dr.GetOrdinal("CountryName"));
}
if (dr.IsDBNull(dr.GetOrdinal("PinID")) == false)
{
objVendorInfo.PinID = dr.GetInt32(dr.GetOrdinal("PinID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ConcernPerson")) == false)
{
objVendorInfo.ConcernPerson = dr.GetInt32(dr.GetOrdinal("ConcernPerson"));
}
if (dr.IsDBNull(dr.GetOrdinal("PhoneNo")) == false)
{
objVendorInfo.PhoneNo = dr.GetInt32(dr.GetOrdinal("PhoneNo"));
}
if (dr.IsDBNull(dr.GetOrdinal("MobileNo")) == false)
{
objVendorInfo.MobileNo = dr.GetInt32(dr.GetOrdinal("MobileNo"));
}
if (dr.IsDBNull(dr.GetOrdinal("Address")) == false)
{
objVendorInfo.Address = dr.GetString(dr.GetOrdinal("Address"));
}
if (dr.IsDBNull(dr.GetOrdinal("EmailID")) == false)
{
objVendorInfo.EmailID = dr.GetString(dr.GetOrdinal("EmailID"));
}
if (dr.IsDBNull(dr.GetOrdinal("WebsiteAddress")) == false)
{
objVendorInfo.WebsiteAddress = dr.GetString(dr.GetOrdinal("WebsiteAddress"));
}
if (dr.IsDBNull(dr.GetOrdinal("PanNo")) == false)
{
objVendorInfo.PanNo = dr.GetString(dr.GetOrdinal("PanNo"));
}
if (dr.IsDBNull(dr.GetOrdinal("GstNo")) == false)
{
objVendorInfo.GstNo = dr.GetString(dr.GetOrdinal("GstNo"));
}
if (dr.IsDBNull(dr.GetOrdinal("ServiceTaxNo")) == false)
{
objVendorInfo.ServiceTaxNo = dr.GetString(dr.GetOrdinal("ServiceTaxNo"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objVendorInfo.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objVendorInfo.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)
{
objVendorInfo.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)
{
objVendorInfo.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)
{
objVendorInfo.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)
{
objVendorInfo.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)
{
objVendorInfo.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID"));
}
if (dr.IsDBNull(dr.GetOrdinal("IsActive")) == false)
{
objVendorInfo.IsActive = dr.GetInt32(dr.GetOrdinal("IsActive"));
}
}
dr.Close();
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(VendorInfo).FullName, 1);
}
return(objVendorInfo);
}
