public List <clsSupplierMasterMember> GetSupplier()
{
List <clsSupplierMasterMember> objList = new List <clsSupplierMasterMember>();
try
{
clsSqlHelper objSql = new clsSqlHelper(clsHelper.DBCONNTYPE.GetConnString);
SqlParameter[] objParams = new SqlParameter[]
{
new SqlParameter("@SupplierID", SupplierID),
new SqlParameter("@UserID", UserID),
new SqlParameter("@CompanyID", CompanyID),
new SqlParameter("@Action", Mode)
};
DataSet ds = objSql.ExecuteDataSet("SupplierMasterGet", objParams);
if (ds != null)
{
clsSupplierMasterMember objSupplier = new clsSupplierMasterMember();
#region Supplier
if (ds.Tables.Count > 0)
{
foreach (DataRow r in ds.Tables[1].Rows)
{
objSupplier.SupplierID = Convert.ToInt32(r["SupplierID"] ?? -1);
objSupplier.SupplierName = (r["SupplierName"] ?? "").ToString();
objSupplier.SupplierAddress = (r["SupplierAddress"] ?? "").ToString();
objSupplier.SupplierStateFKey = Convert.ToInt32(r["SupplierStateFKey"] ?? -1);
objSupplier.SupplierCityFKey = Convert.ToInt32(r["SupplierCityFKey"] ?? -1);
objSupplier.SupplierAreaFKey = Convert.ToInt32(r["SupplierAreaFKey"] ?? -1);
objSupplier.SupplierContactNo = (r["SupplierContactNo"] ?? "").ToString();
objSupplier.SupplierEmail = (r["SupplierEmail"] ?? "").ToString();
objSupplier.SupplierGSTNo = (r["SupplierGSTNo"] ?? "").ToString();
objSupplier.SupplierCSTNo = (r["SupplierCSTNo"] ?? "").ToString();
objSupplier.SupplierIsActive = Convert.ToInt32(r["SupplierActive"] ?? 0);
objSupplier.CompanyID = Convert.ToInt32(r["CompanyID"] ?? 0);
objSupplier.SupplierGSTDate = (r["SupplierGSTDate"] ?? "").ToString();
objSupplier.SupplierCSTDate = (r["SupplierCSTDate"] ?? "").ToString();
objSupplier.SupplierDetai = (r["SupplierDetai"] ?? "").ToString();
objList.Add(objSupplier);
}
}
#endregion
}
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
public List <clsSupplierMasterMember> GetSupplierDetail()
{
List <clsSupplierMasterMember> objList = new List <clsSupplierMasterMember>();
try
{
clsSqlHelper objSql = new clsSqlHelper(clsHelper.DBCONNTYPE.GetConnString);
SqlParameter[] objParams = new SqlParameter[]
{
new SqlParameter("@SupplierID", SupplierID),
new SqlParameter("@UserID", UserID),
new SqlParameter("@CompanyID", CompanyID),
new SqlParameter("@Action", Mode)
};
DataSet ds = objSql.ExecuteDataSet("SupplierMasterGet", objParams);
if (ds != null)
{
clsSupplierMasterMember objSupplier = new clsSupplierMasterMember();
#region Supplier
if (ds.Tables.Count > 0)
{
foreach (DataRow r in ds.Tables[0].Rows)
{
objSupplier.SupplierDetai = (r["SupplierDetai"] ?? "").ToString();
objList.Add(objSupplier);
}
}
#endregion
}
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}