//public CSMaster SelectByIDs(int companyID)
//{
// SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
// return db.Branch.ToList().Where(s => s.CompanyCode == companyID).ToList();
//}
public void save(CSMaster CSMaster, string userId)
{
try
{
using (var context = new SmsMisDB())
{
var mainentry = context.Entry(CSMaster);
if (mainentry != null)
{
int count = 0;
CSMaster.AddDateTime = DateTime.Now;
CSMaster.UserId = userId;
if (CSMaster.CSDetail != null && CSMaster.CSDetail.Count > 0)
{
foreach (var x in CSMaster.CSDetail)
{
x.SrNo = count;
//x.NoteCode = x.NoteCode == null ? string.Empty: x.NoteCode;
//x.FontStyle = x.FontStyle == null ? string.Empty : x.FontStyle;
//x.TopBorder = x.TopBorder == null ? string.Empty : x.TopBorder;
//x.BottomBorder = x.BottomBorder == null ? string.Empty : x.BottomBorder;
count++;
}
}
if (CSMaster.ReportCode == 0)
{
CSMaster.ReportCode = Functions.getNextPk("CSMaster", "ReportCode", string.Concat(" Where CompanyCode =", CSMaster.CompanyCode));
mainentry.State = System.Data.Entity.EntityState.Added;
context.CSMaster.Add(CSMaster);
}
else
{
if (CSMaster.CSDetail != null && CSMaster.CSDetail.Count > 0)
{
CSMaster.CSDetail.ToList().ForEach(i => { i.CompanyCode = CSMaster.CompanyCode; });
CSMaster.CSDetail.ToList().ForEach(i => { i.ReportCode = CSMaster.ReportCode; });
}
mainentry.State = System.Data.Entity.EntityState.Modified;
}
if (CSMaster.CSDetail != null && CSMaster.CSDetail.Count > 0)
{
CSMaster.CSDetail.ToList <CSDetail>().ForEach(entry => context.Entry(entry).State = System.Data.Entity.EntityState.Added);
}
context.CSDetail.ToList().Where(i => i.CompanyCode == CSMaster.CompanyCode && i.ReportCode == CSMaster.ReportCode).ToList <CSDetail>().ForEach(entry => context.Entry(entry).State = System.Data.Entity.EntityState.Deleted);
context.SaveChanges();
}
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
}
catch (Exception ex)
{
}
}
public JsonResult deleteCSMaster(CSMaster CSMaster)
{
try
{
new hdlCSMaster().delete(CSMaster);
}
catch (Exception ex)
{
Response.StatusCode = 500;
Content(JsonConvert.SerializeObject(new { error = ex.Message }));
}
return(getCSMasterByCompany(CSMaster.CompanyCode));
}
public JsonResult saveCSMaster(CSMaster CSMaster)
{
try
{
new hdlCSMaster().save(CSMaster, Convert.ToString(Session["User"]));
//return return getAllCSMaster();
//return Content(JsonConvert.SerializeObject(new { mainObject = getCSMasterByCompany(CSMaster.CompanyCode), subObject = CSMaster }, Formatting.None), "text/json");
}
catch (Exception ex)
{
Response.StatusCode = 500;
Content(JsonConvert.SerializeObject(new { error = ex.Message }));
}
return(getCSMasterByCompany(CSMaster.CompanyCode));
}
public int delete(CSMaster CSMaster)
{
try
{
using (var context = new SmsMisDB())
{
SqlConnection connection = null;
SqlParameter[] aParms = new SqlParameter[] { new SqlParameter("@CompanyCode", CSMaster.CompanyCode), new SqlParameter("@ReportCode", CSMaster.ReportCode) };
try
{
connection = GetConnection(SQL_CONN_STRING);
if (connection == null)
{
return(-2);
}
int i = SqlHelper.ExecuteNonQuery(connection, CommandType.Text, "Delete from CSDetail where CompanyCode=@CompanyCode and reportCode = @ReportCode; Delete from CSMaster WHERE CompanyCode=@CompanyCode and reportCode = @ReportCode;", aParms);
return(i);
}
catch (Exception ex)
{
throw new ExceptionTranslater(ex);
}
finally
{
if (connection != null && connection.State == ConnectionState.Open)
{
connection.Close();
}
}
//var context = new SmsMisDB();
//var mainentry = context.Entry(CSMaster);
//if (mainentry != null)
//{
// if (CSMaster.CSDetail != null && CSMaster.CSDetail.Count > 0)
// {
// CSMaster.CSDetail.ToList().ForEach(i => { i.CompanyCode = CSMaster.CompanyCode; });
// CSMaster.CSDetail.ToList().ForEach(i => { i.ReportCode = CSMaster.ReportCode; });
// }
// //mainentry.State = EntityState.Deleted;
// //if (CSMaster.CSDetail != null && CSMaster.CSDetail.Count > 0)
// //CSMaster.CSDetail.ToList<CSDetail>().ForEach(entry => context.Entry(entry).State = EntityState.Deleted);
// context.CSDetail.ToList().Where(i => i.CompanyCode == CSMaster.CompanyCode && i.ReportCode == CSMaster.ReportCode).ToList<CSDetail>().ForEach(entry => context.Entry(entry).State = EntityState.Deleted);
// //context.VoucherD.ToList().Where(i => i.VoucherNo == CSMaster.VoucherNo).ToList<CSDetail>().ForEach(entry => context.Entry(entry).State = EntityState.Deleted);
// context.CSMaster.Attach(CSMaster);
// mainentry.State = EntityState.Deleted;
// context.SaveChanges();
//}
//var entry = context.Entry(ChartOfAccounts);
//context.ChartOfAccounts.Remove(ChartOfAccounts);
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
//throw SmsMis.Models.Console.Common.ExceptionTranslater.translate(ex);
throw ex;
}
catch (Exception ex)
{
//throw SmsMis.Models.Console.Common.ExceptionTranslater.translate(ex);
throw ex;
}
}
