public LordInfoVM GetLordInfoById(int lordId)
{
LordInfoVM _obj = new LordInfoVM();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("gsp_getLordInfoById", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@lordId", lordId);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
_obj.rptCompanyName = rdr["rptCompanyName"].ToString();
_obj.rptCompanyAddress = rdr["rptCompanyAddress"].ToString();
_obj.lordId = Convert.ToInt16(rdr["lordId"]);
_obj.ownerName = rdr["ownerName"].ToString();
_obj.companyName = rdr["companyName"].ToString();
_obj.companyAddress = rdr["companyAddress"].ToString();
_obj.phoneNo = rdr["phoneNo"].ToString();
_obj.email = rdr["email"].ToString();
_obj.nid = rdr["nid"].ToString();
_obj.createdBy = Convert.ToInt16(rdr["createdBy"]);
_obj.createdDate = Convert.ToDateTime(rdr["createdDate"]);
}
con.Close();
}
return(_obj);
}
public JsonResult InsertOrUpdateLordInfo(LordInfoVM _obj)
{
try
{
_obj.createdBy = Convert.ToInt32(Session["userId"]);
int result = _lordInfoDA.InsertOrUpdateLordInfo(_obj);
if (_obj.lordId == 0)
{
return(Json(new { success = true, message = "Data Saved" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = true, message = "Data Updated" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
//if (ex.Message.Contains("Violation of UNIQUE KEY"))
//{
// return Json(new { success = false, message = "Mobile Number Already Exists!!" }, JsonRequestBehavior.AllowGet);
//}
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public int InsertOrUpdateLordInfo(LordInfoVM _obj)
{
int result = 0;
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("isp_lordInfo", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@lordId", _obj.lordId);
cmd.Parameters.AddWithValue("@ownerName", _obj.ownerName);
cmd.Parameters.AddWithValue("@companyName", _obj.companyName);
cmd.Parameters.AddWithValue("@companyAddress", _obj.companyAddress);
cmd.Parameters.AddWithValue("@phoneNo", _obj.phoneNo);
cmd.Parameters.AddWithValue("@email", _obj.email);
cmd.Parameters.AddWithValue("@nid", _obj.nid);
cmd.Parameters.AddWithValue("@createdBy", _obj.createdBy);
result = 1;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
return(result);
}