public static DataTable GetAll(Entity.Purchase.Vendor vendor)
{
using (DataTable dt = new DataTable())
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_Purchase_VendorMaster_GetAll";
cmd.CommandType = CommandType.StoredProcedure;
if (vendor.CompanyId == 0)
{
cmd.Parameters.AddWithValue("@CompanyId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@CompanyId", vendor.CompanyId);
}
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
private void PopulateVendor()
{
vendormaster = objVendorMaster.GetById(VendorId);
txtVendorName.Text = vendormaster.VendorName;
txtAddress.Text = vendormaster.Address;
ddlState.SelectedValue = Convert.ToString(vendormaster.StateId);
ddlDistrict.SelectedValue = Convert.ToString(vendormaster.DistrictId);
ddlCity.SelectedValue = Convert.ToString(vendormaster.CityId);
txtPin.Text = Convert.ToString(vendormaster.PinId);
txtTAN.Text = vendormaster.Tan;
txtStateCode.Text = vendormaster.StateCode;
txtPAN.Text = vendormaster.Pan;
txtCST.Text = vendormaster.CST;
txtPhoneNo.Text = vendormaster.PhoneNo;
txtMobileNo.Text = vendormaster.MobileNo;
txtFax.Text = vendormaster.Fax;
txtMail.Text = vendormaster.MailId;
txtActiveDate.Text = (vendormaster.ActiveDate == DateTime.MinValue) ? string.Empty : Convert.ToString(vendormaster.ActiveDate.ToString("dd MMM yyyy"));
ddlStatus.SelectedValue = vendormaster.Status.ToString();
txtConcernedPerson.Text = vendormaster.ConcernedPerson;
txtBankName.Text = vendormaster.BankName;
txtBankBranch.Text = vendormaster.BankBranch;
txtACNo.Text = vendormaster.ACNo;
txtIFSC.Text = vendormaster.IFSC;
txtGSTNo.Text = vendormaster.GSTNo;
}
public static int Save(Entity.Purchase.Vendor vendor)
{
int retValue = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "usp_Purchase_VendorMaster_Save";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@VendorId", vendor.VendorId);
cmd.Parameters.AddWithValue("@VendorName", vendor.VendorName);
cmd.Parameters.AddWithValue("@Address", vendor.Address);
cmd.Parameters.AddWithValue("@CountryId", vendor.CountryId);
cmd.Parameters.AddWithValue("@StateId", vendor.StateId);
cmd.Parameters.AddWithValue("@DistrictId", vendor.DistrictId);
cmd.Parameters.AddWithValue("@CityId", vendor.CityId);
cmd.Parameters.AddWithValue("@PinId", vendor.PinId);
cmd.Parameters.AddWithValue("@Tan", vendor.Tan);
cmd.Parameters.AddWithValue("@StateCode", vendor.StateCode);
cmd.Parameters.AddWithValue("@Pan", vendor.Pan);
cmd.Parameters.AddWithValue("@CST", vendor.CST);
cmd.Parameters.AddWithValue("@PhoneNo", vendor.PhoneNo);
cmd.Parameters.AddWithValue("@MobileNo", vendor.MobileNo);
cmd.Parameters.AddWithValue("@Fax", vendor.Fax);
cmd.Parameters.AddWithValue("@MailId", vendor.MailId);
cmd.Parameters.AddWithValue("@UserId", vendor.UserId);
cmd.Parameters.AddWithValue("@CompanyId", vendor.CompanyId);
if (vendor.ActiveDate == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@ActiveDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ActiveDate", vendor.ActiveDate);
}
cmd.Parameters.AddWithValue("@ConcernedPerson", vendor.ConcernedPerson);
cmd.Parameters.AddWithValue("@Bank", vendor.BankName);
cmd.Parameters.AddWithValue("@BankBranch", vendor.BankBranch);
cmd.Parameters.AddWithValue("@ACNo", vendor.ACNo);
cmd.Parameters.AddWithValue("@IFSC", vendor.IFSC);
cmd.Parameters.AddWithValue("@Status", vendor.Status);
cmd.Parameters.AddWithValue("@GSTNo", vendor.GSTNo);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
retValue = cmd.ExecuteNonQuery();
}
}
return(retValue);
}
public static Entity.Purchase.Vendor GetById(int vendorId)
{
Entity.Purchase.Vendor vendor = new Entity.Purchase.Vendor();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "usp_Purchase_VendorMaster_GetById";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@VendorId", vendorId);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
vendor.VendorId = vendorId;
vendor.VendorName = (dr["VendorMasterName"] == DBNull.Value) ? string.Empty : dr["VendorMasterName"].ToString();
vendor.Address = (dr["Address"] == DBNull.Value) ? string.Empty : dr["Address"].ToString();
vendor.CountryId = (dr["CountryId_FK"] == DBNull.Value) ? 0 : int.Parse(dr["CountryId_FK"].ToString());
vendor.StateId = (dr["StateId_FK"] == DBNull.Value) ? 0 : int.Parse(dr["StateId_FK"].ToString());
vendor.DistrictId = (dr["DistrictId_FK"] == DBNull.Value) ? 0 : int.Parse(dr["DistrictId_FK"].ToString());
vendor.CityId = (dr["CityId_FK"] == DBNull.Value) ? 0 : int.Parse(dr["CityId_FK"].ToString());
vendor.PinId = (dr["PinId_FK"] == DBNull.Value) ? 0 : int.Parse(dr["PinId_FK"].ToString());
vendor.Tan = (dr["Tan"] == DBNull.Value) ? string.Empty : dr["Tan"].ToString();
vendor.StateCode = (dr["StateCode"] == DBNull.Value) ? string.Empty : dr["StateCode"].ToString();
vendor.Pan = (dr["Pan"] == DBNull.Value) ? string.Empty : dr["Pan"].ToString();
vendor.CST = (dr["CST"] == DBNull.Value) ? string.Empty : dr["CST"].ToString();
vendor.PhoneNo = (dr["Phone"] == DBNull.Value) ? string.Empty : dr["Phone"].ToString();
vendor.MobileNo = (dr["Mobile"] == DBNull.Value) ? string.Empty : dr["Mobile"].ToString();
vendor.Fax = (dr["Fax"] == DBNull.Value) ? string.Empty : dr["Fax"].ToString();
vendor.MailId = (dr["MailID"] == DBNull.Value) ? string.Empty : dr["MailID"].ToString();
vendor.ActiveDate = (dr["ActiveDate"] == DBNull.Value) ? DateTime.MinValue : DateTime.Parse(dr["ActiveDate"].ToString());
vendor.Status = Convert.ToBoolean(dr["Status"].ToString());
vendor.ConcernedPerson = (dr["ConcernedPerson"] == DBNull.Value) ? "" : dr["ConcernedPerson"].ToString();
vendor.BankName = (dr["Bank"] == DBNull.Value) ? "" : dr["Bank"].ToString();
vendor.BankBranch = (dr["BankBranch"] == DBNull.Value) ? "" : dr["BankBranch"].ToString();
vendor.ACNo = (dr["ACNo"] == DBNull.Value) ? "" : dr["ACNo"].ToString();
vendor.IFSC = (dr["IFSC"] == DBNull.Value) ? "" : dr["IFSC"].ToString();
vendor.GSTNo = dr["GSTNo"].ToString();
}
}
}
}
return(vendor);
}
public DataTable GetAll(Entity.Purchase.Vendor vendorMaster)
{
return(DataAccess.Purchase.Vendor.GetAll(vendorMaster));
}
public int Save(Entity.Purchase.Vendor vendorMaster)
{
return(DataAccess.Purchase.Vendor.Save(vendorMaster));
}