public object DeleteSingleStdDivision(StdWiseDivParam objParam)
{
try
{
Tbl_StandardWiseDivision obj = new Tbl_StandardWiseDivision();
if (objParam.status == 1)
{
obj = db.Tbl_StandardWiseDivision.SingleOrDefault(r => r.StdWiseDivisionId == objParam.StdWiseDivisionId && r.Status == 1);
obj.Status = 0;
db.SaveChanges();
return(new Result {
IsSucess = true, ResultData = "Status Deactivated Successfully"
});
}
else
{
obj = db.Tbl_StandardWiseDivision.SingleOrDefault(r => r.StdWiseDivisionId == objParam.StdWiseDivisionId && r.Status == 0);
obj.Status = 1;
db.SaveChanges();
return(new Result {
IsSucess = true, ResultData = "Status Activated Successfully"
});
}
}
catch (Exception ex)
{
return(new Result {
IsSucess = false, ResultData = "Error"
});
}
}
public object SaveStdWiseDiv(StdWiseDivParam objParam)
{
try
{
objParam.DivisionID = objParam.DivisionID.Trim(',');
string[] division = objParam.DivisionID.Split(',');
int count = 0;
String DivisionName = "";
string StandardName = "";
for (int i = 0; i < division.Length; i++)
{
var divid = Convert.ToInt32(division[i]);
var duplicate = db.View_Display_StandardWiseDivision.SingleOrDefault(r => r.DivisionID == divid && r.StandardID == objParam.StandardID && r.Status == 1);
if (duplicate != null)
{
DivisionName = DivisionName + duplicate.DivisionName + ",";
StandardName = duplicate.StandardName;
count = 1;
}
if (i == division.Length - 1)
{
if (count == 0)
{
Tbl_StandardWiseDivision obj = new Tbl_StandardWiseDivision();
obj.BoardID = objParam.BoardId;
obj.DivisionID = Convert.ToInt64(division[i].ToString());
obj.StandardID = objParam.StandardID;
obj.Status = 1;
obj.CreatedBy = 1;
obj.CreatedDate = DateTime.Now;
obj.ModifiedBy = null;
obj.ModifiedDate = null;
db.Tbl_StandardWiseDivision.Add(obj);
db.SaveChanges();
}
else
{
DivisionName = DivisionName.Trim(',');
StandardName = StandardName.Trim(',');
return(new Result {
IsSucess = true, ResultData = "Division " + DivisionName + " Already Assign to Standard " + StandardName
});
}
}
}
return(new Result {
IsSucess = true, ResultData = "Division Assign Successfully"
});
}
catch (Exception ex)
{
return(new Result {
IsSucess = false, ResultData = "Error"
});
}
}
