public int Insert_Complaint(ComplaintInfo complaintInfo)
{
int complaint_Id = 0;
complaint_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Complaint(complaintInfo), StoredProcedures.Insert_Complaint_Sp.ToString(), CommandType.StoredProcedure));
return(complaint_Id);
}
public ComplaintViewModel()
{
Complaint = new ComplaintInfo();
Complaints = new List <ComplaintInfo>();
Pager = new PaginationInfo();
Friendly_Message = new List <FriendlyMessageInfo>();
Filter = new Complaint_Filter();
}
private ComplaintInfo Get_Complaint_Values(DataRow dr)
{
ComplaintInfo complaint = new ComplaintInfo();
complaint.Complaint_Id = Convert.ToInt32(dr["Complaint_Id"]);
complaint.Customer_Name = Convert.ToString(dr["Customer_Name"]);
complaint.Order_Id = Convert.ToInt32(dr["Order_Id"]);
complaint.Challan_No = Convert.ToInt32(dr["Challan_No"]);
complaint.CDescription = Convert.ToString(dr["CDescription"]);
return(complaint);
}
private List <SqlParameter> Set_Values_In_Complaint(ComplaintInfo complaintInfo)
{
List <SqlParameter> sqlParamList = new List <SqlParameter>();
if (complaintInfo.Complaint_Id != 0)
{
sqlParamList.Add(new SqlParameter("@Complaint_Id", complaintInfo.Complaint_Id));
}
sqlParamList.Add(new SqlParameter("@Customer_Id", complaintInfo.Customer_Id));
sqlParamList.Add(new SqlParameter("@Order_Id", complaintInfo.Order_Id));
sqlParamList.Add(new SqlParameter("@Challan_No", complaintInfo.Challan_No));
sqlParamList.Add(new SqlParameter("@Description", complaintInfo.CDescription));
if (complaintInfo.Complaint_Id == 0)
{
sqlParamList.Add(new SqlParameter("@CreatedBy", complaintInfo.CreatedBy));
}
sqlParamList.Add(new SqlParameter("@UpdatedBy", complaintInfo.UpdatedBy));
return(sqlParamList);
}
public ComplaintInfo Get_Complaint_By_Id(int complaint_Id)
{
ComplaintInfo complaint = new ComplaintInfo();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Complaint_Id", complaint_Id));
DataTable dt = _sqlRepo.ExecuteDataTable(sqlParams, StoredProcedures.Get_Complaint_By_Id_Sp.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
int count = 0;
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
count = drList.Count();
foreach (DataRow dr in drList)
{
complaint = Get_All_Complaint_Values(dr);
}
}
return(complaint);
}
public IList <ComplaintInfo> Report(ComplaintInfo keywords)
{
return(client.Report(keywords));
}
public int Modify(ComplaintInfo node)
{
return(client.Modify(node));
}
public int Update(ComplaintInfo node)
{
return(client.Update(node));
}
public int Create(ComplaintInfo node)
{
return(client.Create(node));
}
public IList <ComplaintInfo> Read(ComplaintInfo keyowrds)
{
return(client.Select(keyowrds));
}
public void Update_Complaint(ComplaintInfo complaintInfo)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Complaint(complaintInfo), StoredProcedures.Update_Complaint_Sp.ToString(), CommandType.StoredProcedure);
}
public ActionResult _Items(ComplaintInfo keywords)
{
return(PartialView(models.Complaint.Report(keywords)));
}
public ActionResult _List(ComplaintInfo keywords)
{
return(PartialView(models.Complaint.Read(keywords)));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ComplaintInfo model, IDbTransaction transaction = null)
{
return(_ComplaintInfoRepository.Update(model, transaction));
}
/// <summary>
/// 新增
/// </summary>
public int Add(ComplaintInfo model, IDbTransaction transaction = null)
{
return(_ComplaintInfoRepository.Insert(model, transaction));
}
public int Insert_Complaint(ComplaintInfo complaintInfo)
{
return(_cRepo.Insert_Complaint(complaintInfo));
}
public void Update_Complaint(ComplaintInfo complaintInfo)
{
_cRepo.Update_Complaint(complaintInfo);
}
public int _Modify(ComplaintInfo node)
{
return(models.Complaint.Modify(node));
}
