public ActionResult Insert_Data_Help(CommanMasterHelp CMH)
        {
            try
            {
                int result1 = _objCM.insert_data_help(CMH);
                if (result1 == 1)
                {
                    ViewBag.Message = "Record Save Sucessfully !";
                }
                return Json(new { success = true, responseText = "Record Save Sucessfully!" }, JsonRequestBehavior.AllowGet);
            }
            catch (Exception)
            {

                throw;
            }
        }
        public int insert_data_help(CommanMasterHelp CMH)
        {
            try
            {
                _cn.Open();
                SqlCommand _cmd = new SqlCommand("sp_save_usermaster_help", _cn);
                _cmd.CommandType = CommandType.StoredProcedure;
                _cmd.Parameters.AddWithValue("@xmaster", CMH.xmaster);
                _cmd.Parameters.AddWithValue("@Field1", CMH.Field1);
                _cmd.Parameters.AddWithValue("@Field2", CMH.Field2);
                _cmd.Parameters.AddWithValue("@Field3", CMH.Field3);
                _cmd.Parameters.AddWithValue("@Field4", CMH.Field4);
                _cmd.Parameters.AddWithValue("@Field5", CMH.Field5);
                _cmd.Parameters.AddWithValue("@Field6", CMH.Field6);
                _cmd.Parameters.AddWithValue("@Field7 ", CMH.Field7);
                _cmd.Parameters.AddWithValue("@Field8", CMH.Field8);
                _cmd.Parameters.AddWithValue("@Field9", CMH.Field9);
                _cmd.Parameters.AddWithValue("@Field10", CMH.Field10);
                _cmd.Parameters.AddWithValue("@Field11", CMH.Field11);
                _cmd.Parameters.AddWithValue("@Field12", CMH.Field12);
                _cmd.Parameters.AddWithValue("@Field13", CMH.Field13);
                _cmd.Parameters.AddWithValue("@Field14", CMH.Field14);
                _cmd.Parameters.AddWithValue("@Field15", CMH.Field15);
                _cmd.Parameters.AddWithValue("@Field16", CMH.Field16);
                _cmd.Parameters.AddWithValue("@Field17", CMH.Field17);
                _cmd.Parameters.AddWithValue("@Field18", CMH.Field18);
                _cmd.Parameters.AddWithValue("@Field19", CMH.Field19);
                _cmd.Parameters.AddWithValue("@Field20", CMH.Field20);
                _cmd.Parameters.AddWithValue("@Language ", CMH.Language);
                _cmd.Parameters.AddWithValue("@Attribute1", CMH.Attribute1);
                _cmd.Parameters.AddWithValue("@Attribute2", CMH.Attribute2);
                _cmd.Parameters.AddWithValue("@Attribute3", CMH.Attribute3);
                _cmd.Parameters.AddWithValue("@Attribute4", CMH.Attribute4);
                _cmd.Parameters.AddWithValue("@Attribute5", CMH.Attribute5);
                _cmd.Parameters.AddWithValue("@Attribute6", CMH.Attribute6);
                _cmd.Parameters.AddWithValue("@Attribute7", CMH.Attribute7);
                _cmd.Parameters.AddWithValue("@Attribute8", CMH.Attribute8);
                _cmd.Parameters.AddWithValue("@Attribute9", CMH.Attribute9);
                _cmd.Parameters.AddWithValue("@Attribute10", CMH.Attribute10);
                _cmd.Parameters.AddWithValue("@Rating1", CMH.Rating1);
                _cmd.Parameters.AddWithValue("@Rating2", CMH.Rating2);
                _cmd.Parameters.AddWithValue("@Rating3", CMH.Rating3);

                _cmd.Parameters.AddWithValue("@Date1", CMH.Date1);
                _cmd.Parameters.AddWithValue("@Date2", CMH.Date2);
                _cmd.Parameters.AddWithValue("@Date3", CMH.Date3);

                _cmd.Parameters.AddWithValue("@Email1", CMH.Email1);
                _cmd.Parameters.AddWithValue("@Email2", CMH.Email2);
                _cmd.Parameters.AddWithValue("@Email3", CMH.Email3);
                _cmd.Parameters.AddWithValue("@Amount", CMH.Amount);
                _cmd.Parameters.AddWithValue("@Amount2", CMH.Amount2);
                _cmd.Parameters.AddWithValue("@Amount3", CMH.Amount3);
                _cmd.Parameters.AddWithValue("@Time1", CMH.Time1);
                _cmd.Parameters.AddWithValue("@Time2", CMH.Time2);
                _cmd.Parameters.AddWithValue("@Html", CMH.Html);
                _cmd.Parameters.AddWithValue("@Upload", CMH.Upload);
                _cmd.Parameters.AddWithValue("@TextArea", CMH.TextArea);
                _cmd.Parameters.AddWithValue("@MultiSelect1", CMH.MultiSelect1);
                _cmd.Parameters.AddWithValue("@MultiSelect2", CMH.MultiSelect2);
                _cmd.Parameters.AddWithValue("@MultiSelect3", CMH.MultiSelect3);
                _cmd.Parameters.AddWithValue("@MultiSelect4", CMH.MultiSelect4);
                _cmd.Parameters.AddWithValue("@MultiSelect5", CMH.MultiSelect5);
                _cmd.Parameters.AddWithValue("@CreatedBy", CMH.CreatedBy);
                if (CMH.EntryDatetime == null)
                {
                    _cmd.Parameters.AddWithValue("@EntryDatetime", DBNull.Value);
                }
                else
                {
                    _cmd.Parameters.AddWithValue("@EntryDatetime", DateTime.ParseExact(CMH.EntryDatetime, "dd/MM/yyyy", null));
                }
                _cmd.Parameters.AddWithValue("@EditedBy", CMH.EditedBy);

                if (CMH.EditDatetime == null)
                {
                    _cmd.Parameters.AddWithValue("@EditDatetime", DBNull.Value);
                }
                else
                {
                    _cmd.Parameters.AddWithValue("@EditDatetime", DateTime.ParseExact(CMH.EditDatetime, "dd/MM/yyyy", null));
                }
                _cmd.Parameters.AddWithValue("@CorpcentreBy", CMH.CorpcentreBy);
                _cmd.Parameters.AddWithValue("@UnitCorpBy", CMH.UnitCorpBy);
                _cmd.Parameters.AddWithValue("@TerminalBy", CMH.TerminalBy);
                int i = _cmd.ExecuteNonQuery();
                return i;
            }
            catch
            {
                throw;
            }
            finally
            {
                _cn.Close();
                _cn.Dispose();
            }

        }