public ActionResult Insert_Data(CommanMaster CM)
{
try
{
DataSet result = _objCM.insert_data(CM);
if (result != null)
{
ViewBag.Message = result.Tables[0].Rows[0]["msg"].ToString();
if (result.Tables[0].Rows[0]["Help"].ToString() == "Save" || result.Tables[0].Rows[0]["Help"].ToString() == "Update")
{ ViewBag.Event = "success"; }
else if (result.Tables[0].Rows[0]["Help"].ToString() == "Duplicate")
{ ViewBag.Event = "error"; }
}
var result1 = ViewBag.Message;
return Json(new { success = result1, Event = ViewBag.Event }, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
throw;
}
}
public PartialViewResult _PartialCountry(string ViewId, string MasterCode, string corporate, string Unit, string Location, string Branch, string UserId, string Type)
{
DataSet dsList = _objCM.bindViewsControls(ViewId, MasterCode, corporate, Unit, Location, Branch, UserId, Type);
CommanMaster CV = new CommanMaster();
Views _grid = new Views();
List<ViewsGridHearder> GridHearder = new List<ViewsGridHearder>();
List<ViewsGridColumn> GridColumn = new List<ViewsGridColumn>();
List<Views> lstGrid = new List<Views>();
if (dsList.Tables[0].Rows.Count > 0)
{
ViewBag.GridHearder = dsList.Tables[0];
ViewBag.GridColumn = dsList.Tables[1];
if (dsList.Tables[0] != null)
{
foreach (System.Data.DataRow dr in ViewBag.GridColumn.Rows)
{
GridColumn.Add(new ViewsGridColumn
{
column1 = @dr["column1"].ToString(),
column2 = @dr["column2"].ToString(),
column3 = @dr["column3"].ToString(),
column4 = @dr["column4"].ToString()
});
}
}
if (dsList.Tables[1] != null)
{
foreach (System.Data.DataRow dr in ViewBag.GridHearder.Rows)
{
GridHearder.Add(new ViewsGridHearder
{
Header = @dr["Header"].ToString(),
DisplayOrder = @dr["DisplayOrder"].ToString(),
Visibility = @dr["Visibility"].ToString(),
TableColumn = @dr["TableColumn"].ToString()
});
// var gf = GridColumn.Where(s => s.SrNo == dr["xcode"].ToString()).ToList();
}
}
}
_grid.ViewsGridColumn = GridColumn.ToList();
_grid.ViewsGridHearder = GridHearder.ToList();
lstGrid.Add(_grid);
return PartialView(lstGrid);
}
/* insert Basic details
ADMIN_MASTER
*/
public DataSet insert_data(CommanMaster CM)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_save_adminmaster", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Parameters.AddWithValue("@Type", CM.Type);
_cmd.Parameters.AddWithValue("@xmaster", CM.xmaster);
_cmd.Parameters.AddWithValue("@xname", CM.xname);
_cmd.Parameters.AddWithValue("@drpCaption", CM.drpCaption);
_cmd.Parameters.AddWithValue("@xlink", CM.xlink);
_cmd.Parameters.AddWithValue("@xcross", CM.xcross);
_cmd.Parameters.AddWithValue("@xcross1", CM.xcross1);
_cmd.Parameters.AddWithValue("@xcross2", CM.xcross2);
_cmd.Parameters.AddWithValue("@xcross3 ", CM.xcross3);
_cmd.Parameters.AddWithValue("@xcross4", CM.xcross4);
_cmd.Parameters.AddWithValue("@xreference1 ", CM.xreference1);
_cmd.Parameters.AddWithValue("@xreference2 ", CM.xreference2);
_cmd.Parameters.AddWithValue("@xreference3 ", CM.xreference3);
_cmd.Parameters.AddWithValue("@xreference4 ", CM.xreference4);
_cmd.Parameters.AddWithValue("@xreference5 ", CM.xreference5);
_cmd.Parameters.AddWithValue("@xreference6 ", CM.xreference6);
_cmd.Parameters.AddWithValue("@xdetail ", CM.xdetail);
_cmd.Parameters.AddWithValue("@ENTRYCONTROL ", CM.ENTRYCONTROL);
_cmd.Parameters.AddWithValue("@SEGMENT ", CM.SEGMENT);
_cmd.Parameters.AddWithValue("@Attribute1", CM.Attribute1);
_cmd.Parameters.AddWithValue("@Attribute2", CM.Attribute2);
_cmd.Parameters.AddWithValue("@Attribute3", CM.Attribute3);
_cmd.Parameters.AddWithValue("@Attribute4", CM.Attribute4);
_cmd.Parameters.AddWithValue("@Attribute5", CM.Attribute5);
_cmd.Parameters.AddWithValue("@Attribute6", CM.Attribute6);
_cmd.Parameters.AddWithValue("@Attribute7", CM.Attribute7);
_cmd.Parameters.AddWithValue("@Attribute8", CM.Attribute8);
_cmd.Parameters.AddWithValue("@Attribute9", CM.Attribute9);
_cmd.Parameters.AddWithValue("@Attribute10", CM.Attribute10);
_cmd.Parameters.AddWithValue("@Rating1", CM.Rating1);
_cmd.Parameters.AddWithValue("@Rating2", CM.Rating2);
_cmd.Parameters.AddWithValue("@Rating3", CM.Rating3);
_cmd.Parameters.AddWithValue("@Date1", CM.Date1);
_cmd.Parameters.AddWithValue("@Date2", CM.Date2);
_cmd.Parameters.AddWithValue("@Date3", CM.Date3);
_cmd.Parameters.AddWithValue("@Email1", CM.Email1);
_cmd.Parameters.AddWithValue("@Email2", CM.Email2);
_cmd.Parameters.AddWithValue("@Email3", CM.Email3);
_cmd.Parameters.AddWithValue("@Amount", CM.Amount);
_cmd.Parameters.AddWithValue("@Amount2", CM.Amount2);
_cmd.Parameters.AddWithValue("@Amount3", CM.Amount3);
_cmd.Parameters.AddWithValue("@Time1", CM.Time1);
_cmd.Parameters.AddWithValue("@Time2", CM.Time2);
_cmd.Parameters.AddWithValue("@Html", CM.Html);
_cmd.Parameters.AddWithValue("@Upload", CM.Upload);
_cmd.Parameters.AddWithValue("@TextArea", CM.TextArea);
_cmd.Parameters.AddWithValue("@MultiSelect1", CM.MultiSelect1);
_cmd.Parameters.AddWithValue("@MultiSelect2", CM.MultiSelect2);
_cmd.Parameters.AddWithValue("@MultiSelect3", CM.MultiSelect3);
_cmd.Parameters.AddWithValue("@MultiSelect4", CM.MultiSelect4);
_cmd.Parameters.AddWithValue("@MultiSelect5", CM.MultiSelect5);
_cmd.Parameters.AddWithValue("@CreatedBy", CM.CreatedBy);
if (CM.EntryDatetime == null)
{
_cmd.Parameters.AddWithValue("@EntryDatetime", DBNull.Value);
}
else
{
_cmd.Parameters.AddWithValue("@EntryDatetime", DateTime.ParseExact(CM.EntryDatetime, "dd/MM/yyyy", null));
}
_cmd.Parameters.AddWithValue("@EditedBy", CM.EditedBy);
if (CM.EditDatetime == null)
{
_cmd.Parameters.AddWithValue("@EditDatetime", DBNull.Value);
}
else
{
_cmd.Parameters.AddWithValue("@EditDatetime", DateTime.ParseExact(CM.EditDatetime, "dd/MM/yyyy", null));
}
_cmd.Parameters.AddWithValue("@CorpcentreBy", CM.CorpcentreBy);
_cmd.Parameters.AddWithValue("@UnitCorpBy", CM.UnitCorpBy);
_cmd.Parameters.AddWithValue("@TerminalBy", CM.TerminalBy);
_cmd.Parameters.AddWithValue("@language", CM.language);
_cmd.Parameters.AddWithValue("@Corporate", CM.Corporate);
//int i = _cmd.ExecuteNonQuery();
SqlDataAdapter _adp = new SqlDataAdapter(_cmd);
DataSet _ds = new DataSet();
_adp.Fill(_ds);
_adp.Dispose();
_cmd.Dispose();
return _ds;
}
catch
{
throw;
}
finally
{
_cn.Close();
_cn.Dispose();
}
}
