/// <summary> /// Function for view the copied Master details by form name /// </summary> /// <param name="formName"></param> /// <returns></returns> public MasterInfo MasterCopyViewByFormName(int formName) { MasterInfo infoMaster = new MasterInfo(); try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sqlcmd = new SqlCommand("MasterCopyViewByFormName", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@formName", SqlDbType.Int).Value = formName; SqlDataReader sqldr = sqlcmd.ExecuteReader(); while (sqldr.Read()) { infoMaster.MasterId = int.Parse(sqldr["masterId"].ToString()); infoMaster.FormName = int.Parse(sqldr["formName"].ToString()); infoMaster.IsTwoLineForHedder = bool.Parse(sqldr["isTwoLineForHedder"].ToString()); infoMaster.IsTwoLineForDetails = bool.Parse(sqldr["isTwoLineForDetails"].ToString()); infoMaster.PageSize1 = int.Parse(sqldr["pageSize1"].ToString()); infoMaster.PageSizeOther = int.Parse(sqldr["pageSizeOther"].ToString()); infoMaster.BlankLneForFooter = int.Parse(sqldr["blankLneForFooter"].ToString()); infoMaster.FooterLocation = sqldr["footerLocation"].ToString(); infoMaster.LineCountBetweenTwo = int.Parse(sqldr["lineCountBetweenTwo"].ToString()); infoMaster.Pitch = sqldr["pitch"].ToString(); infoMaster.Condensed = sqldr["condensed"].ToString(); infoMaster.LineCountAfterPrint = int.Parse(sqldr["lineCountAfterPrint"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.Message, "MasterViewByFormName", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { sqlcon.Close(); } return(infoMaster); }