public static Entity.Service.CallStatus GetById(int callStatusId)
{
Entity.Service.CallStatus contract = new Entity.Service.CallStatus();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Parameters.AddWithValue("@CallStatusId", callStatusId);
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Service_CallStatus_GetById";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
if (dr.HasRows)
{
contract.CallStatusId = callStatusId;
contract.CallStatusName = dr["CallStatus"].ToString();
}
}
con.Close();
}
}
return(contract);
}
public static int Save(Entity.Service.CallStatus callStatus)
{
int rowsAffacted = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_Service_CallStatus_Save";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CallStatusId", callStatus.CallStatusId);
cmd.Parameters.AddWithValue("@CallStatus", callStatus.CallStatusName);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
rowsAffacted = cmd.ExecuteNonQuery();
con.Close();
}
}
return(rowsAffacted);
}
protected void gvCallStatus_RowCommand(object sender, GridViewCommandEventArgs e)
{
Business.Service.CallStatus objCallStatus = new Business.Service.CallStatus();
Entity.Service.CallStatus CallStatus = new Entity.Service.CallStatus();
if (e.CommandName == "Ed")
{
int callStatusId = int.Parse(e.CommandArgument.ToString());
CallStatus = objCallStatus.GetById(callStatusId);
CallStatusId = CallStatus.CallStatusId;
txtCallStatusName.Text = CallStatus.CallStatusName;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Business.Service.CallStatus objCallStatus = new Business.Service.CallStatus();
Entity.Service.CallStatus CallStatus = new Entity.Service.CallStatus();
CallStatus.CallStatusId = CallStatusId;
CallStatus.CallStatusName = txtCallStatusName.Text;
int i = objCallStatus.Save(CallStatus);
if (i > 0)
{
ClearControls();
LoadCallStatus();
Message.IsSuccess = true;
Message.Text = "Call Status saved successfully...";
}
else
{
Message.IsSuccess = false;
Message.Text = "Can not save!!!";
}
Message.Show = true;
}
public int Save(Entity.Service.CallStatus callStatus)
{
return(DataAccess.Service.CallStatus.Save(callStatus));
}
