public List <clsCustomerMasterMember> GetCustomer()
{
List <clsCustomerMasterMember> objList = new List <clsCustomerMasterMember>();
try
{
clsSqlHelper objSql = new clsSqlHelper(clsHelper.DBCONNTYPE.GetConnString);
SqlParameter[] objParams = new SqlParameter[]
{
new SqlParameter("@CustomerID", CustomerID),
new SqlParameter("@UserID", UserID),
new SqlParameter("@CompanyID", CompanyID),
new SqlParameter("@Action", Mode)
};
DataSet ds = objSql.ExecuteDataSet("CustomerMasterGet", objParams);
if (ds != null)
{
clsCustomerMasterMember objCustomer = new clsCustomerMasterMember();
#region Customer
if (ds.Tables.Count > 0)
{
foreach (DataRow r in ds.Tables[1].Rows)
{
objCustomer.CustomerID = Convert.ToInt32(r["CustomerID"] ?? -1);
objCustomer.CustomerName = (r["CustomerName"] ?? "").ToString();
objCustomer.CustomerAddress = (r["CustomerAddress"] ?? "").ToString();
objCustomer.CustomerStateFKey = Convert.ToInt32(r["CustomerStateFKey"] ?? -1);
objCustomer.CustomerCityFKey = Convert.ToInt32(r["CustomerCityFKey"] ?? -1);
objCustomer.CustomerAreaFKey = Convert.ToInt32(r["CustomerAreaFKey"] ?? -1);
objCustomer.CustomerContactNo = (r["CustomerContactNo"] ?? "").ToString();
objCustomer.CustomerEmail = (r["CustomerEmail"] ?? "").ToString();
objCustomer.CustomerGSTNo = (r["CustomerGSTNo"] ?? "").ToString();
objCustomer.CustomerCSTNo = (r["CustomerCSTNo"] ?? "").ToString();
objCustomer.CustomerIsActive = Convert.ToInt32(r["CustomerActive"] ?? 0);
objCustomer.CompanyID = Convert.ToInt32(r["CompanyID"] ?? 0);
objCustomer.CustomerGSTDate = (r["CustomerGSTDate"] ?? "").ToString();
objCustomer.CustomerCSTDate = (r["CustomerCSTDate"] ?? "").ToString();
objCustomer.CustomerDetai = (r["CustomerDetai"] ?? "").ToString();
objCustomer.CustomerPanNo = (r["CustomerPanNo"] ?? "").ToString();
objList.Add(objCustomer);
}
}
#endregion
}
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
public List <clsCustomerMasterMember> GetCustomerDetail()
{
List <clsCustomerMasterMember> objList = new List <clsCustomerMasterMember>();
try
{
clsSqlHelper objSql = new clsSqlHelper(clsHelper.DBCONNTYPE.GetConnString);
SqlParameter[] objParams = new SqlParameter[]
{
new SqlParameter("@CustomerID", CustomerID),
new SqlParameter("@UserID", UserID),
new SqlParameter("@CompanyID", CompanyID),
new SqlParameter("@Action", Mode)
};
DataSet ds = objSql.ExecuteDataSet("CustomerMasterGet", objParams);
if (ds != null)
{
clsCustomerMasterMember objCustomer = new clsCustomerMasterMember();
#region Customer
if (ds.Tables.Count > 0)
{
foreach (DataRow r in ds.Tables[0].Rows)
{
objCustomer.CustomerDetai = (r["CustomerDetai"] ?? "").ToString();
objList.Add(objCustomer);
}
}
#endregion
}
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
