public tbl_Color ColorSelectColorById(Guid Id)
{
tbl_Color model = new tbl_Color();
try
{
DataTable dt = new DataTable();
using (SqlConnection connection = new SqlConnection(db.Database.Connection.ConnectionString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand("Sp_ColorManage", connection))
{
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand.CommandTimeout = 0;
adapter.SelectCommand.Parameters.Add(new SqlParameter("@action", "GetColorById"));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@UniqueId", Id));
adapter.Fill(dt);
}
connection.Close();
}
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
model.Color_Id = Convert.ToInt32(row["Color_Id"]);
model.Color_Name = Convert.ToString(row["Color_Name"]);
model.Color_Code = Convert.ToString(row["Color_Code"]);
model.IsActive = Convert.ToBoolean(row["IsActive"]);
model.UniqueId = !string.IsNullOrEmpty(Convert.ToString(row["UniqueId"])) ? Guid.Parse(Convert.ToString(row["UniqueId"])) : Guid.Parse("00000000-0000-0000-0000-000000000000");
}
}
}
catch (Exception ex)
{
throw ex;
}
return(model);
}
public int ManageColor(tbl_Color model, string ManageType)
{
int response = 0;
if (ManageType == "Update")
{
using (SqlConnection connection = new SqlConnection(db.Database.Connection.ConnectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand("Sp_ColorManage", connection);
cmd.Parameters.AddWithValue("@ColorId", model.Color_Id);
cmd.Parameters.AddWithValue("@ColorName", model.Color_Name);
cmd.Parameters.AddWithValue("@ColorCode", model.Color_Code);
cmd.Parameters.AddWithValue("@ManageType", ManageType);
cmd.CommandType = CommandType.StoredProcedure;
response = cmd.ExecuteNonQuery();
connection.Close();
}
}
if (ManageType == "Insert")
{
using (SqlConnection connection = new SqlConnection(db.Database.Connection.ConnectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand("Sp_ColorManage", connection);
cmd.Parameters.AddWithValue("@ColorName", model.Color_Name);
cmd.Parameters.AddWithValue("@ColorCode", model.Color_Code);
cmd.Parameters.AddWithValue("@ManageType", ManageType);
cmd.CommandType = CommandType.StoredProcedure;
response = cmd.ExecuteNonQuery();
//response = Convert.ToInt32(cmd.Parameters["@CategoryId"].Value);
connection.Close();
}
}
return(response);
}
