public ssmtbl_CustomerVendorMasterModel GetOneVendor(int Id)
{
ssmtbl_CustomerVendorMasterModel objVend = new ssmtbl_CustomerVendorMasterModel();
try
{
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "ssmsp_Get_AllVendor";
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", Id);
cmd.Parameters.AddWithValue("@Action", "GetVendorByID");
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
objVend.Name = sdr["Name"].ToString();
objVend.Telephone_No = (sdr["Telephone_No"].ToString());
objVend.STD_Code = Convert.ToInt32(sdr["STD_Code"].ToString());
objVend.Address = sdr["Address"].ToString();
objVend.City = sdr["City"].ToString();
objVend.Pincode = Convert.ToInt32(sdr["Pincode"].ToString());
objVend.Contact_Person = sdr["Contact_Person"].ToString();
objVend.Email_ID = sdr["Email_ID"].ToString();
objVend.Mobile_No = Convert.ToInt32(sdr["Mobile_No"].ToString());
objVend.Remarks = sdr["Remarks"].ToString();
objVend.Vendor_Code = sdr["Vendor_Code"].ToString();
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objVend);
}
// # region Insert Contact Person
//public string InsertCPIntoDB(long id)
//{
// string s = "";
// string vc = "0";
// try
// {
// var connection = gConnection.Connection();
// connection.Open();
// string sqlstr = "ssmsp_Get_AllVendor";
// SqlCommand cmd = new SqlCommand(sqlstr, connection);
// cmd.CommandType = System.Data.CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@type", "vendor");
// cmd.Parameters.AddWithValue("@Action", "FindmaxVendorCode");
// SqlDataReader sdr = cmd.ExecuteReader();
// while (sdr.Read())
// {
// vc = (sdr["Vendor_Code"].ToString());
// s = vc == "" ? "VC-00001" : ("VC-" + ((Convert.ToInt64(vc.Split('-')[1]) + 1).ToString("00000")));
// }
// connection.Close();
// }
// catch (Exception ex)
// {
// s = "VC-00001";
// ErrorHandlerClass.LogError(ex);
// }
// return s;
//}
//#endregion
#region Get All Vendor
public List <ssmtbl_CustomerVendorMasterModel> GetAllVendor()
{
List <ssmtbl_CustomerVendorMasterModel> objVendorList = new List <ssmtbl_CustomerVendorMasterModel>();
try
{
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "ssmsp_Get_AllVendor";
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "Select");
cmd.Parameters.AddWithValue("@Type", "vendor");
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ssmtbl_CustomerVendorMasterModel objtemp = new ssmtbl_CustomerVendorMasterModel();
objtemp.ID = Convert.ToInt32(sdr["ID"].ToString());
objtemp.Name = sdr["Name"].ToString();
objtemp.Address = (sdr["Address"].ToString());
objtemp.City = sdr["City"].ToString();
objtemp.Pincode = Convert.ToInt32(sdr["Pincode"].ToString());
objtemp.Vendor_Code = ((sdr["Vendor_Code"])).ToString();
var remark = ((sdr["Remarks"])).ToString();
objtemp.Remarks = remark == "" ? "NA" : remark;
objVendorList.Add(objtemp);
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objVendorList);
}
