public ActionResult _CustomerInforPartial(ReportSearchViewModel model)
{
var CusInfo = new ReportCusInforViewModel();
try
{
using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.CommandText = "usp_ThongTinCongNoKhachHang";
cmd.Parameters.AddWithValue("@CustomerId", model.CustomerId);
cmd.Parameters.AddWithValue("@FromDate", model.FromDate);
cmd.Parameters.AddWithValue("@ToDate", model.ToDate);
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
CusInfo = SingleView(dr);
}
conn.Close();
return(PartialView(CusInfo));
}
}
}
catch
{
return(PartialView(CusInfo));
}
}
public ReportCusInforViewModel ListView(SqlDataReader s)
{
ReportCusInforViewModel ret = new ReportCusInforViewModel();
try
{
if (s["CustomerId"] != null)
{
ret.CustomerId = Int32.Parse(s["CustomerId"].ToString());
}
if (s["FullName"] != null)
{
ret.FullName = s["FullName"].ToString();
}
if (s["Phone"] != null)
{
ret.Phone = s["Phone"].ToString();
}
if (s["Email"] != null)
{
ret.Email = s["Email"].ToString();
}
if (s["CustomerLevelName"] != null)
{
ret.CustomerLevelName = s["CustomerLevelName"].ToString();
}
if (s["SoDuNoDauKy"] != DBNull.Value)
{
ret.SoDuNoDauKy = decimal.Parse(s["SoDuNoDauKy"].ToString());
}
if (s["SoDuNoCuoiKy"] != DBNull.Value)
{
ret.SoDuNoCuoiKy = decimal.Parse(s["SoDuNoCuoiKy"].ToString());
}
}
catch { }
return(ret);
}
public ReportCusInforViewModel SingleView(SqlDataReader s)
{
ReportCusInforViewModel ret = new ReportCusInforViewModel();
try
{
if (s["FullName"] != null)
{
ret.FullName = s["FullName"].ToString();
}
if (s["Phone"] != null)
{
ret.Phone = s["Phone"].ToString();
}
if (s["Email"] != null)
{
ret.Email = s["Email"].ToString();
}
if (s["Address"] != null)
{
ret.Address = s["Address"].ToString();
}
if (s["BirthDay"] != DBNull.Value)
{
ret.BirthDay = Convert.ToDateTime(s["BirthDay"].ToString());
}
if (s["GenderString"] != null)
{
ret.GenderString = s["GenderString"].ToString();
}
if (s["ProvinceName"] != null)
{
ret.ProvinceName = s["ProvinceName"].ToString();
}
if (s["DistrictName"] != null)
{
ret.DistrictName = s["DistrictName"].ToString();
}
if (s["CustomerLevelName"] != null)
{
ret.CustomerLevelName = s["CustomerLevelName"].ToString();
}
if (s["NoPhaiThu"] != DBNull.Value)
{
ret.NoPhaiThu = decimal.Parse(s["NoPhaiThu"].ToString());
}
if (s["SoDuNoDauKy"] != DBNull.Value)
{
ret.SoDuNoDauKy = decimal.Parse(s["SoDuNoDauKy"].ToString());
}
if (s["SoDuNoCuoiKy"] != DBNull.Value)
{
ret.SoDuNoCuoiKy = decimal.Parse(s["SoDuNoCuoiKy"].ToString());
}
}
catch { }
return(ret);
}
