public CareTakerVM GetCareTakerById(int careTakerId)
{
CareTakerVM _obj = new CareTakerVM();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("gsp_getCareTakers", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@careTakerId", careTakerId);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
_obj.rptCompanyName = rdr["rptCompanyName"].ToString();
_obj.rptCompanyAddress = rdr["rptCompanyAddress"].ToString();
_obj.careTakerId = Convert.ToInt16(rdr["careTakerId"]);
_obj.careTakerName = rdr["careTakerName"].ToString();
_obj.presentAddress = rdr["presentAddress"].ToString();
_obj.permanentAddress = rdr["permanentAddress"].ToString();
_obj.phoneNo = rdr["phoneNo"].ToString();
_obj.email = rdr["email"].ToString();
_obj.nid = rdr["nid"].ToString();
_obj.joiningDate = rdr["joiningDate"] == System.DBNull.Value ? (DateTime?)null : Convert.ToDateTime(rdr["joiningDate"]);
_obj.joiningDateString = rdr["joiningDateString"].ToString();
_obj.salary = Convert.ToDecimal(rdr["salary"]);
_obj.isActiveString = rdr["isActiveString"].ToString();
_obj.isActive = Convert.ToBoolean(rdr["isActive"]);
_obj.createdBy = Convert.ToInt16(rdr["createdBy"]);
_obj.createdDate = Convert.ToDateTime(rdr["createdDate"]);
}
con.Close();
}
return(_obj);
}
public JsonResult InsertOrUpdateCareTaker(CareTakerVM _obj)
{
try
{
_obj.createdBy = Convert.ToInt32(Session["userId"]);
if (_obj.joiningDateString != null)
{
_obj.joiningDate = DateTime.ParseExact(_obj.joiningDateString, "dd/MM/yyyy", null);
}
int result = _da.InsertOrUpdateCareTaker(_obj);
if (_obj.careTakerId == 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 InsertOrUpdateCareTaker(CareTakerVM _obj)
{
int result = 0;
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("isp_careTaker", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@careTakerId", _obj.careTakerId);
cmd.Parameters.AddWithValue("@careTakerName", _obj.careTakerName);
cmd.Parameters.AddWithValue("@presentAddress", _obj.presentAddress);
cmd.Parameters.AddWithValue("@permanentAddress", _obj.permanentAddress);
cmd.Parameters.AddWithValue("@phoneNo", _obj.phoneNo);
cmd.Parameters.AddWithValue("@email", _obj.email);
cmd.Parameters.AddWithValue("@nid", _obj.nid);
cmd.Parameters.AddWithValue("@joiningDate", _obj.joiningDate);
cmd.Parameters.AddWithValue("@salary", _obj.salary);
cmd.Parameters.AddWithValue("@isActive", _obj.isActive);
cmd.Parameters.AddWithValue("@createdBy", _obj.createdBy);
result = 1;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
return(result);
}
