public int Delete(CRM.BusinessLayer.LevelMasterBL OLevelDelete, SqlConnection Con, int argLevelId)
{
int j = 0;
try
{
SqlCommand cmd = new SqlCommand("Delete FROM dbo.Level_Master WHERE LevelId='" + argLevelId + "'", Con);
j = cmd.ExecuteNonQuery();
}
catch (Exception e)
{
BsfGlobal.CustomException(e.Message, e.StackTrace);
}
return(j);
}
public int Update(CRM.BusinessLayer.LevelMasterBL OLevelUpdate)
{
int j = 0;
try
{
SqlCommand cmd = new SqlCommand("UpdateLevelProc", BsfGlobal.OpenCRMDB());
cmd.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < OLevelUpdate.DtLevel.Rows.Count; i++)
{
if (OLevelUpdate.DtLevel.Rows[i]["LevelID"].ToString() == string.Empty)
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Flag", 1);
cmd.Parameters.AddWithValue("@LevelName", OLevelUpdate.DtLevel.Rows[i]["LevelName"].ToString());
cmd.Parameters.AddWithValue("@SortOrder", i + 1);
cmd.Parameters.AddWithValue("@LevelID", DBNull.Value);
j = cmd.ExecuteNonQuery();
}
else
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Flag", 2);
cmd.Parameters.AddWithValue("@LevelID", OLevelUpdate.DtLevel.Rows[i]["LevelID"].ToString());
cmd.Parameters.AddWithValue("@LevelName", OLevelUpdate.DtLevel.Rows[i]["LevelName"].ToString());
cmd.Parameters.AddWithValue("@SortOrder", i + 1);
j = cmd.ExecuteNonQuery();
}
}
}
catch (Exception e)
{
BsfGlobal.CustomException(e.Message, e.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
return(j);
}
